Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Apple Draniel
  Where is Apple Draniel?
 Bucharest
 Romania
 Apple Draniel
 Tags
Subject: Connection Time too long mysql
Thread ID: 228697 Message ID: 228697 # Views: 4 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Wednesday, May 20, 2009 9:18:56 PM         
   


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.

ENTIRE THREAD

Connection Time too long mysql Posted by Apple Draniel @ 5/20/2009 9:18:56 PM
RE: Connection Time too long mysql Posted by Tom Saddul @ 5/21/2009 2:04:26 AM
RE: Connection Time too long mysql Posted by anand kulkarni @ 5/29/2009 11:17:45 AM