Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Graham Brown
  Where is Graham Brown?
 East Midlands
 United Kingdom
 Graham Brown
 Tags
Subject: Design questions (list newbie question)
Thread ID: 33963 Message ID: 33963 # Views: 2 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Friday, December 05, 2003 2:21:15 PM         
   


Hi all

I've been working in VFP6 and Codemine for a while now, what my apps tend to do is open the vfp tables directly in the scx data environment. Recently one of my apps has been running incredibly slowly so I guess its probably time for a design rethink.
I already program in ASP/VB/COM and SQL Server so I am familiar with the DB and ADO connectivity but I suppose I'm look for the best way to get a VFP app running both with a native backend or a SQL Server backend depending upon the end user.

If I understand the material I've read (Whil's book!) then the best bet is to create a DBC containing tables which should be shared for all users. A separate DBC containing either local or remote views for each user held locally. Whils' book mentions using a public datasession to aid performance, but coming from a clipper background this tended to cause major headaches with record pointers. I think I'd prefer to keep the data sessions private but again I'm not sure if that is the best bet.

Could anyone advise on design strategy

Regards

Graham



ENTIRE THREAD

Design questions (list newbie question) Posted by Graham Brown @ 12/5/2003 2:21:15 PM
RE: Design questions (list newbie question) Posted by Eric den Doop @ 12/5/2003 2:32:54 PM
RE: Design questions (list newbie question) Posted by Graham Brown @ 12/5/2003 2:55:20 PM
RE: Design questions (list newbie question) Posted by Eric den Doop @ 12/5/2003 7:57:32 PM
RE: Design questions (list newbie question) Posted by Graham Brown @ 12/18/2003 4:57:24 PM