Performance problems with VB 6 Data bound Controls

[GoldLake]

I have a VB 6.0 program that uses a data control with FoxPro 2.5 files. The program works well internally but remote users on a 56K line are so slow they are getting network/disk errors.

I am setting the connect property to FoxPro 2.5, the database name to the path, a Jet DataSource, a RecordsetType of Dynaset and a Select statment in the RecordSource property.

Does anyone have any ideas?

 

[rgbean]

Unless you are very careful about limiting the number of records you get at a given time (like you'd do in a true client-server type application), there isn't much hope of getting "good" response time over a 56K- line. Note: While I've not used VB / Jet extensively, this is based on experience with ODBC / OLEDB with other data sources in a WAN environment. The access time has got nothing to do with FoxPro or the DBF structures - just the amount of data you application is trying to "haul" over the phone line.

Rick


Rick

 

[GoldLake]

The select statment is only selecting one record and occasionally when it does not get an error it takes four or five minutes to return and display the record.

 

[rgbean]

Wow, unless that's one HUGE record, it's difficult to understand that kind of delay. Have you attached a line monitor to watch what's actually being brought down to the local system? It's sounds like Jet might be bringing down all the data locally to process and then just give the single record RS to your local application.

Rick
(I made sure I didn't "stutter" my name this time !)

 

[GoldLake]

A line monitor sounds good. Where do I get one?

 

[MikeWood]

I have a lot of experience with FP apps over dial up lines.

Rule 1 when using dbf files - Only access small files on the server.

Even though you are selecting small result sets, your remote PC is still having to read through the entire file to complete the query.

The real solution is a backend database (such as SQL Server) where the query processing is done on the backend and then returns the result set to the remote PC.
Mike Wood
mikewood@mpwonline.com