Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>I redid an existing form using a view to local (LAN) tables. The form uses 4 or 5 views all based on the serial number (C 8) of the parent record. Initial query openig the form and Requery is taking 5-6 secs on each view pulling data from tables with about 100,000 rows. I am surprised that it takes so long considering that there is an index on the field being used in the where clause. Have I overlooked something. Server is running Windows Server 2003 and there are only about 10 PCs on the network
>
>Thanks.
It would be good to show the SQL of the views along with indexes. Initial query tends to take longer. If you open the tables at app startup, then subsequent use again even in private data session forms will be faster. I also use create cursor instead of SQL to create empty cursors for the initial startup/binding. Only query the real table when needed.
Previous
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