Query Types

[emblic]

Hi,

I have a query which takes quite a while to run and do its thing (on my original data) Is there a way of overcoming this? What I mean is: What must I do for the query to use only the latest data which was entered and not do its computations each and every time that it is run.

 

[sstreet]

Speeding up queries:
1. Do not use select *, but instead select only the fields you require.
2. Use the WHERE function to limit the results of the query.

Create or use a field that records the date that the record was created, you can then use this date in the query to select on the data entered in the last week, month, year.

Hope this helps!