If the fact that more than one user is on the app slows the query, can you try to open the tables exclusively or to FLOCK() them just to see what happens ?
Another way should be to build a COM object staying on the server and doing all the heavy queries and creating cursors or returning XML datas; but here I reach the limit of my knowledge !!! The Foxil _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
