thanks for your replies..i found out the slowness was due to a bug in winxp. as pointed to by christian, a setting on odbc fixed the bug.. on another topic i cant help but noticed that you used a view to populate the table.. i had a related issue which i think you've found a solution to..the view you used to connect to mysql has numeric and integer fields. Using VFP6 and mysql 5.0, views returns character fields for equivalent numeric fields on mysql tables.
in your example you are able to: insert into x (C6) values (100.55) whereas in i had to do this: insert into x (c6) values (str(100.55,10,2))
also when i browse, c6 fields are characters (left justified).