>>Hi All,
>>
>>I'm trying to work out why a locally running copy of Sybase SQL Anywhere accessed through ODBC should be 8-10 times slower than ODBC accessing a SQL Server on the network.
>>
>>Does anybody know of anything I could do to speed up the SQL AnyWhere ODBC - or at least certain things to try if you have no experience of SQL AnyWhere.??
>>
>>TIA
>>
>>Ian
>>Philip Morris SA
>
>Hello Ian
>
>I have been using SYBASE ANYWHERE here in Paris. The experience has been successful including speed ... but i worked on limited quantities of information. Could you be more specific on your difficulties (quantities of information, nature of the operations that are slow).
>
>You mention that ODBC could be the problem. If your difficult relate to data retrieval, try your SELECT string both from Anywhere ISQL and thru SQLEXEC.
>You might find situation where Anywhere is the problem ... and some where OBBC is.
>
>I have never been stuck with speed issues until recently as i discovered that the optimizer of the new 5.5 version is clearly not as good as his version 4. and version 5.O one when running highly complex SELECT strings! just waiting for version 6.
>
>Good luck
Hi Francoise,
To give you a bit more information:
The problem appears to be with ODBC because the command
SELECT * FROM employee
which returns 440 records
via SQLEXEC - 6 seconds
via ISQL - approx 1 seconds
Any ideas?
Ian
regards
Ian