Hi Carlos,
Seems you have been down this path before!
> and yes, it takes about 28 seconds to create the view.
That's faster than what I experienced bu that may simply be a speed difference between our respective machines. In either case, even 28 seconds is way too long to simply create a remote view. A few questions:
1.) When you switched on the MySQL log. Where is that log file created? Do I need to have a special debug version of the ODBC driver, and if so where can I find that driver? I used that OPTIONS parameter but did not get a log file that I could find.
-- 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`;
2.) This is interesting. The ( _latin1'NULL') is strange and I see that you have reported that previously. Why is it that the log shows a plain ( SELECT * FROM mycfstble )? Is that something you put into VFP code via a USE statement or is that also the result of just creating the remote view? This SELECT * is what I sort of suspected was happening....
I will report this as a bug to MySQL once I get some log files and backup documentation and I'll be sure to let you know!
Alec