>Hi,
>
>When one of the features of the application is called (VFP form is opened), my application loads ALL records from the SQL Server DB. This is a spare parts table. Let's put aside that - maybe - I need to change the logic and get only those records the user needs.
>Right now, one of the customers has about 25000 record in this table. They timed that it takes from 30 to 40 seconds to load them into the application window. Is it reasonable (I know it is subjective), but in general?
>
>I use the code
>
>select * from MyTable
>
>when pulling all records.
>
>How can I improve the above SQL Select?
>
>TIA
>
>UPDATE. The customer just sent me an email and wrote that sometimes pulling the records takes as little as 3 seconds. Just like right now.
>
>UPDATE 2. Actually I found that the query is not "select * ..." but listing all fields/columns of the table. So, the query is:
>
>select field1, field2... and so on from MyTable
>
>
>I probably need to change this to "select * "
There is nothing to improve on the query.
You need to think on how to avoid having to download the whole table and only get those when you need them.