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 ?
Speed of return of registers
Moderators: gto, cipto_kh, EgonHugeist
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
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