PFCSIG How to increase speed when retrieving data into datawindow

[Andrew Subhagia T.]

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