Hi all!

I have a table with 300.000 records (pk, name, lastname, fk_loc) and another child table loca (pk_loc) on mysql server. In vfp9 exist a view with parameter by (parameterized). This view connected on mysql by ODBC. If i query view with my parameter answer is quite rapidely. This view it's included on form in dataenvironment and NoDataOnLoad is set true. When i run form this will load very slowly (time to -AutoOpen it's verrrry long). After the form it's activated requery on my view works ok (answer time is short).

I don't now way the time for load is very long on my form even view is initialy nodata.

It's possible to view definition to be transmited on server and compiled or server will be query even nodataonload propertty is set to true ? I don't now what is happen ? I use Asynchrone mode.

My remote view seeting is: "SendUpdates",.F.; "BatchUpdateCount",1; "CompareMemo",.F. ;"FetchAsNeeded",.T. ; "FetchMemo",.F. ; "FetchSize",100 ; "MaxRecords",-1 ; "Prepared",.F. ; "ShareConnection",.T. ; "AllowSimultaneousFetch",.T. ; "UpdateType",1 ; "UseMemoSize",255 ; "WhereType",3 ; "ParameterList","nc_name,'C'".

Any suggestion would be apprecieted .

Thanks in advance.