General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
I am displaying a subset of a table in a grid .
First of all I started using a filter
The table contains 0.5 million records and will grow to maybe 1 million records.
Currently it takes about 5 seconds to refresh the grid based on the filter.
I need to reduce this and so I decided to use SQL as the recordsource type
Instead it now takes longer. The time seems to be used up re-setting
the recordsourcetype . I would have expected it to take less time
maybe 1 second or less.
thisform.grid2.recordsourcetype=4
thisform.grid2.recordsource="select * from v_avail;
where v_avail.villa_id=villas.idcode ;
and DATE>=thisform.fdate and DATE into cursor temp1"
Views I believe take even longer. This is on a form which users
are constantly going in and out of and are impatient with the
time delay in refreshing the form.
Any ideas would be appreciated
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only