I did some tests to use compress on my MySQL connections
Well my test: (I used the trial version of Devart DbExpress)
Using 'Devart MySQL'
before connect i did
SQLConnection.Params.Add('Custom String=Compress=True');
so the application works fine !
SQLConnection.Open;
I did a SQL Statement 'show status like '%compress%''
The result from server -> variable_name = Compression; Value = ON
Very good
the compress is working.but Using 'Devart MySQL Direct'
The result from server -> variable_name = Compression; Value = OFF
Well, my conclusion is that 'Devart MySQL Direct' havent suport compress.
Its OK to me, i will use 'Devart MySQL', not 'Devart MySQL Direct' on my app.
But about my conclusion, is it right ?
Roberto Novakosky