Smart Client Running very slow

[Infop]

Hi all,

Our solution is running really Fine in Servoy 5.2 with PostgreSQL. I have tried to migrate the database (including the repository server) to the MySQL 5.1. It went well. But, the application is running very slow. I imported the solution with data to the Application Server with Server Connection connecting to MySQL Databases. I think, this should work fine. Do I need to take some special considerations?

Thanks

[ptalbot]

You might want to have a look at your indexes.
I don't think that Servoy is taking care of that when importing.

[ROCLASI]

I don't think that Servoy is taking care of that when importing.

That is correct. Servoy will not create any indices for you.
There is no standard way to create an index (in fact it's not in the SQL spec at all) so Servoy doesn't know how to.

[Infop]

Thank you, Patrick and Robert.

I will look at the indices for my database tables.

Thanks,

[Infop]

Yes, the issue is due to the indices. I have to manually copy them. Is there any tool to do a complete DB conversion from PostgreSQL/iAnywhere to MySQL? Does anybody have any information?

Thanks,

[Harjo]

we have good result with EMS SQL pump,

http://www.sqlmanager.net/en/products/p ... l/datapump

or for mySQL: http://www.sqlmanager.net/en/products/mysql/datapump

for sybase, you can use the ADO version...
there are also, version, for mysql, postgresql etc..etc..