On Mon, Dec 1, 2008 at 11:45 AM, Steve Ellenoff <[EMAIL PROTECTED]> wrote: < bla bal bal
> Knowing the driver cannot support async mode, it's no surprise that > the code hangs/blocks at the SQLEXEC line as it must wait for the > PostgreSQL server to finish executing the select statement. Since I'm > pulling all records on a large table, this is simply a slow process. > --------------------------------- There lies the design problem. You are thinking in the local fox data mindset and have not considered that other engines do not work well for working with large data sets. Why not request the first reduction of data be done before the entire table is downloaded? Secondly do you need every column of data? The narrower your return table is the FASTER it comes back. I have found that if you use a go bott go top you will really raise the speed of your data returning. -- Stephen Russell Sr. Production Systems Programmer Mimeo.com Memphis TN 901.246-0159 _______________________________________________ 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.
