Re: PFCSIG How to increase speed when retrieving data into datawindow

[Daniel Coppersmith]

If you are retrieving a lot of rows, you can use retrieveAsNeeded.  Whenever I think I need retrieveAsNeeded, I always rethink what I am doing... does the user need (or even want) to see all those?  I often add criteria that limits the data (by customer number, by date, etc.)... you can also find some kind of grouping and create an explorer-type interface with a tree on the left and the data on the right... orders by region-territory-customer for example....   If you are not retrieving a lot of rows and the SQL runs slow, you might need to examine your SQL... are you doing unnessesary joins?  Table scans?  Would an index on the table help?  If you are joining to another table to get a description (state name from the state table since the customer table only has the state code) you might want to consider a dropdown datawindow that will display the state name since it will retrieve it only once for the datawindow and then you can eliminate that join.   If the SQL looks okay, check your code.  Are you doing a lot of unnecessary computations in your datawindow?  Do you have any code in the retrieveRow event?  Code in there (even just comments I've heard) slow down the retrieval.   If all of the above fail, is your network response time slow?   Good luck,   Daniel ----- Original Message ----- From: Andrew Subhagia T. To: [EMAIL PROTECTED] Sent: Friday, December 10, 1999 4:36 PM Subject: PFCSIG How to increase speed when retrieving data into datawindow Anybody knows how to speed up retrieving data in datawindow ???   I had a lot of records in my table using MS.Sql 7.0 and I create window with datawindow to show a list of that records. I had to wait almost more than a minute until it appear on my datawindow buffer. To make it appear on first retrieve I use scrollnextrow() function but still can't help me alot to have a flash retrieve. It show on my datawindow vertival scrollbar is moving, while its not finish retrieving, I can not do anything until it completely done.   Anyone knows ??? Please help ... Best regards, Andrew Subhagia T. PT. KOBA TIN