Ted,
Make sure that the following are all indexed;
- the columns on each side of any join of the underlying view query,
- the criteria columns for the underlying view query,
- any view columns that the user's query may use to join to other
table(s),
- any view columns that will have criteria applied in the user's
query.
You specifically want to avoid any full table scans, and any cartesian
products in the joins.
Ideally the user query should execute in a couple of seconds, while
Witango's manipulations of the data will take a few seconds as well.
Regards,
Jason.
On 31/03/2008, at 1:31 PM, Ted Wolfley wrote:
A view is being used to link data between 6 tables where the user
can search at least 10 fields bringing back about 40 columns.
--
This message has been scanned for viruses and
dangerous content by ESVA, and is
believed to be clean.
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
