Hi Joshua, > Making the MySQL indexes would be your responsibility. Importing the data > would most likely not import the index definitions also. You need to > recreate those. Your explain seems to indicate that you have *no* indexes on > your table. I would guess that your query doesn't hang it just takes a very > long time to return.
I'm not a MySQL hacker, but... > > Joshua, maybe there are some ineficient indexes, I don't know, because > > the MSSQL database was not made by me. Iam just trying to migrate the > > database to MYSQL and check that everything works fine. > > My query is > > "SELECT * FROM postulantes LIMIT 1,30" Why should this query use any indices? With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
