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 * "
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
