On Mon, Dec 1, 2008 at 12:40 PM, Steve Ellenoff <[EMAIL PROTECTED]> wrote: > 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). > ----------------------------------------------------------
Sounds like a tough overhaul to push that functionality back on the server. Maybe you can't change your process because of all the other reporting requirements? Best of luck. -- 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.

