Page 1 of 1

Speed of return of registers

Posted: 28.12.2005, 18:12
by aliotti
I need return the more faster to user. How do it ?
On my sql browser have parameter: Use compression protocol that return compressed the registers, how do in zeos to use this parameter ? :?:

Posted: 09.06.2006, 00:46
by fduenas
there are some parameters you have to specify in the 'Parameters' property of TZConnection

some of them are:

compress=[yes,no] - Turn on/off compression protocol

dbless=[yes,no] - Connect to the real database or not (dbless mode)

useresult=[yes,no] - Fetching rows using UseResult instead StoreResult.

timeout=<seconds> - Connection timeout in seconds.

codepage=<client codepage> - Sets a client codepage. It executes a SET CHARACTER SET <client codepage> statement righ after connect. Right now MySQL supports only cp1251_koi8 value. Refer your MySQL server manual for details.


Regards