Our shop has used FoxPro exclusively, until 6 months ago, for about 5 years. We have switched to SQL Server because our primary job tracking application (3rd Party) switched. We have found FoxPro (especially since v5.0) to be very stable and robust. If you design the database properly, use referential integrity and transactions (the most important item!) it is very robust. While our FoxPro databases will sometimes get a "corrupt index", or an index that points to the wrong record, they are easily fixed. As long as you can get exclusive use of the tables (which we do by getting in early and locking people out) a simple reindex command against the offending table will fix the index. We have had to reindex tables with 700,000 records and 10 indexes and it takes about 2 minutes across a 100bt network (doing it local on the server would be faster). Basically if I had a choice of using Access 2000 or FoxPro I would pick FoxPro every time. Hope this helps, if you have any questions feel free to ask. ______________________________________________________ Bill Grover Supervisor IS Department Phone: 301.424.3300 x396 EU Services, Inc. FAX: 301.424.3300 x1396# 649 North Horners Lane E-Mail: mailto:[EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: www.euservices.com ______________________________________________________ > -----Original Message----- > Date: Mon, 27 Mar 2000 09:55:40 -0600 > From: "Dave Hannum" <[EMAIL PROTECTED]> > To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> > Subject: FoxPro and Access 2000 > Message-ID: <00fd01bf9804$e6a92880$[EMAIL PROTECTED]> > > Good Morning, > > Any thoughts on using Access 2000 or FoxPro for production > databases. Now, I know previous versions of Access have not been > recommended for web production, but it seems there has bee > some discussion about Access 2000 being more robust than > Access 97. I've > never used FoxPro, but the host where my next project is to > be hosted supports Access 2000 and FoxPro for the account my > client has. > Just looking for input. Also, what about mySQL. The next > level account the host offers supports mySQL. Should I > encourage them to > upgrade? How hearty is mySQL? I use Oracle for most of my > work, and only have experience with Access for a very small > site. I've > never used FoxPro or mySQL. I know that none of these three > (especially Access) even come close to Oracle, but we'll be developing > on a shared host server. Marketing says potential for this > site is $3M annually - gotta be robust! > > Thanks, > Dave > > > ================================= > "Technology" is stuff that was invented after > you were born. > > David Hannum > > ------------------------------ ------------------------------------------------------------------------------ Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
