>I'm using VFP with MySQL database.
>and I figured out it that every (remote) view will cost MySQL one connection.
>
something totally different from your OP.
Using a singular connection for all views on each backend is good practice.

>That why I tried to convert some views to public variables in order to save the resources.

views are cursors - moving the data into memvars is often counterproductive.
If you need it, try to work via a pattern similar to ActiveRecord.
I personally prefer scattering to a special .oData on a biz object or a CA in this case.

HTH

thomas