How to speed up retrieving in datawindow?

[paul102384]

Hi to all pb programmers,

I just want to ask if there is some technique or method on how to speed up retrieving in datawindow?Because i tend to used embedded sql in datawindow may be that's why it slow down the retrieving process. any suggestions would be appreciated.

thank you in advance....

 

[mbalent]

Check the db indexes. Don't Filter the data after it's retrieved. Create a view on the DB and use it as the datawindow data source.
Narrow your criteria for the data.

Matt

"Nature forges everything on the anvil of time"

http://www.anvil-of-time.com

 

[paul102384]

thanks mbalent