Performance Problem (SQL & DAO 3.6)

[Raggart]

Hi,

I have a nasty performance problem for my application. I use DAO 3.6 and SQL commands to update a table in a DBase III database. I use an Advantage Database Server ODBC driver to connect to the database and to update the indexes. Here is the code I use for my update statement:

"UPDATE Requis SET L_MERX=0 WHERE C_SEQUENCE='" & strNuméroSéquence & "'"

(sorry about the french characters in there, can't help it :)

My problem is that it takes at least 15 seconds just to make ONE update. The table only has 8500 records, so I'm kind of puzzled. Could it be the ODBC driver ?

Any help would be appreciated.

Thanks,

Raggart

[Raggart]

Oooops. Forget about this, I just found out that the ODBC driver supplied allowed for manual index selection and I had not selected the indexes :-)

There should be a way to cancel threads, I could have removed this, but hey, sorry if someone took some time to think about this problem!

Raggart