>Hi Carlos,
>
>Thanks for the reply and for sticking with me on this issue!
No problem, I use MySql myself so I am interested in too.
OK, I created a table using your table layout, filled it with 200k records, and yes, it takes about 28 seconds to create the view. I switched on the MySql log (option 524288) and this is what i got:
-- Query logging
--
-- Driver name: MySQL ODBC 5.1 Driver Version: 05.01.0005
-- Timestamp: 081007 20:52:42
;
SELECT * FROM mycfstble Mycfstble WHERE cfs_index = _latin1'NULL';
;
SELECT * FROM mycfstble;
SHOW KEYS FROM `mycfstble`;
I guess this
http://bugs.mysql.com/bug.php?id=35067 and this
http://bugs.mysql.com/bug.php?id=38544 has not been really fixed completely yet. Well, at least it doesn´t crash VFP now!
I guess your best bet is to file a bug report there.
Try enabling logging and check if there is any difference in the myodbc.sql file between the views that are fast and the ones that are slow, if you file a bug report, mention it here and I will post in it too.
By the way, check this one
http://bugs.mysql.com/bug.php?id=35581 to see what to expect when mentioning VFP there :-)
Carlos Alloatti