There are several possibilities to look at here. However, the first step
should be to get the Profiler up and running & see which bits of sql are
taking too long.
You may find your indexing strategy needs re-examining. Or it may be
that your server is not set to 'update statistics' for itself
(auto-updating is a new feature in 7).
'update statistics' is used to build information about index composition
so that the query optimization processes can make intelligent decisions.
If your data has changed significantly, and the statistics have not been
updated, SQL will make bad decisions on the method of query execution -
net result = slow queries.
Another useful place to go is SQL Books Online & look up 'Query Tuning'.
Hope this helps.
Posted At: 6 December 1999 5:07am
Posted To: odbc
Conversation: ODBC Timeout Expired Erro!!
Subject: ODBC Timeout Expired Erro!!
I'm using SQL7 SP1 everything was working fine until I started adding
data to my existing database. It is now approx 7.8M records and over
size. I am getting Timeout expired errors constantly now to the point
the program is somewhat unusable. Could someone please help me out..
this a trait of SQL7 when dealing with larger size databases. I was
SQLAnywhere before and it handled it fine I was looking for a
gain in going withn SQL7 but as of yet have received none...
thanks in advance, rks...