Hi Stephen- Thanks for your reply. Yes, I'm very aware that select * is a foxpro mentality, I was only using it to test out the async functionality. In fact, my app runs just fine w/o async for the very reason that I only pull columns I need and I always use a fairly restrictive where clause. I've read all the how to design a c/s fox books, although I don't pretend to be perfect at eliminating the fox mindset yet either.. :)
The issue for me is that for some of the existing reports, there's a ton of tabulation going on which means that often the entire recordset or a large part of it is included. In places where I can't keep the work on the backend, I wanted to implement asyc handling so the user wouldn't think the report locked up. I wasn't looking to try to make the report run faster via async, just to provide ui assistance to the user. Some of these reports are slow in VFP also.. Now, I don't mean 10 minutes slow (usually between 30 seconds and 3 minutes). At 02:00 PM 12/01/2008, Stephen Russell wrote: >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? What do you mean by this, can you give an example? >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. I don't understand what you mean by go bott, go top in relation to pulling from the backend. _______________________________________________ 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.
