From the tests I have done, here is where and how speed on sql statments gets improved.
in no specific order - try any of these.
1 dont use remote views.
2 if your server uses or cann use store proceedures, have your dbm write them or get the most common sql statments written into stored proceedures.
3 use spt (sqlexec) a
4 you might try to see if sqlprepare() speeds up your querries. - it might a little
5 limit the number of records your sql stament returns down to 50 or so (if you can)
6 limit the actual fields being returned, to just the fields you need for your forms, or reports.
7 find out where your sql statment is slowing you down. (sometimes its the loging which can slow someone down) if thats the case, keep logged and dont issue a sqldisconnect() until they leave the application.
Bob lee
>What is the best code to use in client/server based application so that data retrieval will improve by 50%? We are currently using SQL statements where the query results will be stored in a cursor and then it (cursor) is then associated with a grid as a record source.
>
>Thanks and More Power To The Fox,
>
>
>Jun K.
In the beginning, there was a command prompt, and all was well.