Re: SQL upsizing
From: Edhy Rijo (erijo_at_msn.com.NO_SPAM)
Date: 03/16/05
- Next message: Tom C.: "Calling HTML Help in VFP 6"
- Previous message: Tim Witort: "Slight VFP9 oddity"
- In reply to: Jeff Grippe: "Re: SQL upsizing"
- Next in thread: Dan Freeman: "Re: SQL upsizing"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 16 Mar 2005 14:30:02 -0500
Hi Jeff,
I agree with Dan, but make not mistake, if your application requires to use
a SQL database MS, MySQL or ORACLE, then your programming habit must change.
Your users will get used to the new way of getting the data and will really
appreciate the speed gain if they are suffering some kind of slow data
retrieval now.
Maybe it is even time to do an overhaul to the application. If you are not
using a framework, I will suggest you to start shopping around for a good
one that really support Client Server. I use Visual ProMatrix
www.promatrix.com for many years and am really happy with it. The idea
behind the framework is to use classes already proven that will expedite the
application development and help you with the C/S stuff, and get ready to
use remote views, cursor adapters and in some cases SQL Pass Through (SPT)
to get your data for some custom procedures.
Good Luck!
-- Edhy Rijo www.progytech.com Bronx NY Visual ProMatrix Life MVP! "Jeff Grippe" <jgrippe@hilldun.com> wrote in message news:113guut55cc3lcf@news.supernews.com... > This is going to be a very hard sell to my users who have gotten used to > certain ways of doing things such as "Browsing all customers". I saw the > client/server fox book and while it seems like a must have it doesn't > cover the specific topic of converting non-c/s apps in as much detail as I > need. > > Where are the 15 years worth of articles? > > Thanks, > > Jeff > "Dan Freeman" <spam@microsoft.com> wrote in message > news:OrVMUGlKFHA.1176@TK2MSFTNGP12.phx.gbl... >> Jeff Grippe wrote: >>> Has anyone been through this type of conversion and can you tell me >>> how you've solved some of these problems? Are there any articles or >>> books that specifically address moving from VFP Tables to SQL server >>> based databases? >> >> There are about 15 years' worth of articles out there, and several books. >> Start here: >> >> http://www.hentzenwerke.com/catalog/csvfp.htm >> >> Your entire mindset needs to change when moving to a client/server >> architecture. The "zen" is to only retrieve those records needed for the >> current task. Browse all customers? NO! You ask for a name and bring back >> only those that are a close match for a picklist if needed. >> >> The mantra is to minimize the amount of data traveling across the wire. >> >> Your SEEKs and REPLACEs are still possible using remote views, preferably >> parameterized to limit their size. >> >> Good luck! >> >> Dan >> >> > >
- Next message: Tom C.: "Calling HTML Help in VFP 6"
- Previous message: Tim Witort: "Slight VFP9 oddity"
- In reply to: Jeff Grippe: "Re: SQL upsizing"
- Next in thread: Dan Freeman: "Re: SQL upsizing"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
