>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only