Do you have a question? Post it now! No Registration Necessary. Now with pictures!
February 27, 2007, 7:02 am
rate this thread
for a VB application.
OPTION=3 is Don't Optimised Column Width (1) and Return Matching Rows (2).
I found this to be very slow on a database with just 27,000 records. It took
approx. 12 seconds to read 27,000 records.
When I change the OPTION to 8 (Allow Big Results), it took just 3 seconds to
read 27,000 records. BUT now my application cannot update records anymore
and getting random errors on transactions.
I try setting OPTION=11 (all 3 options added together) and the speed went
back to being slow.
Can someone please help?
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum