> 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.

hi bucharest
what type of config. u have with ur computer .
regards
anand


There is no Age to learn