Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Eric den Doop
  Where is Eric den Doop?
 Houten
 Netherlands
 Eric den Doop
 To: Graham Brown
  Where is Graham Brown?
 East Midlands
 United Kingdom
 Graham Brown
 Tags
Subject: RE: Design questions (list newbie question)
Thread ID: 33963 Message ID: 33965 # Views: 2 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Friday, December 05, 2003 2:32:54 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
>


VFP8 has the CursorAdapter class. This is a common interface for accessing different data sources. Here's an excellent article by Chuck Urwiler.
Introducing the CursorAdapter Class.
--
Eric den Doop
www.foxite.com - The Home Of The Visual FoxPro Experts

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