I have tested the connection, and unfortunately my provider doesn't ALLOW remote connections a mySQL database. So i can't test the speed or compression.
In the MM business object I added the following line of code.
protected override mmDataAccessBase CreateDataAccessObject(string dataAccessClassName)
{
return new Apps4u.WinApp.Managers.a4uDataAccessMySql();
}
I am going to install MySQL on my machine and test it locally, unless someone wants to offer a MySQL connection for me.
Just send me and email with the details and I will try it, if possible, I would like to load test the ByteFx connection, something like 100 records, 1000 records and 100,000 records just to see what happens. The records could be just a primary key and a char column, I don't really care I just want to test the connection.
Thanks!