Visual Basic App using Foxpro DB vs Access DB vs SQL Server DB 
Author Message
 Visual Basic App using Foxpro DB vs Access DB vs SQL Server DB

I'm planning to create a VB application and am trying to figure out how
to best store the DB.  The DB tables can have as much as 500,000 records
in them and can be well over 100MB in size.

Which DB format will work best with VB.  I want the queries to run
quick.  Will storing the DB in Foxpro take advantage of FoxPro's
Rushmore technology.  What about an SQL Server?

Thanks

Sailesh



Sun, 10 Jan 1999 03:00:00 GMT
 Visual Basic App using Foxpro DB vs Access DB vs SQL Server DB

Quote:

>I'm planning to create a VB application and am trying to figure out how
>to best store the DB.  The DB tables can have as much as 500,000 records
>in them and can be well over 100MB in size.
>Which DB format will work best with VB.  I want the queries to run
>quick.  Will storing the DB in Foxpro take advantage of FoxPro's
>Rushmore technology.  What about an SQL Server?
>Thanks
>Sailesh

Picking the best database is a little like picking the best car... It
depends upon how much money you have and your personal preferences.

If you have the money to implement SQL Server and a good number of
concurrent users, I would go with SQL Server.  It is a true
client/server implementation and you will get better performance,
improved reliability, transaction processing, data security, to name a
few features.

Second, I would go with Access.  A VB application that uses a FoxPro
database goes through the Jet database engine anyway, so you lose some
overhead by using FoxPro.

You can develop your initial prototype with a standalone Access
database and upsize it to SQL Server very easily.

Jerry Helms
Intelligent Information Systems



Mon, 11 Jan 1999 03:00:00 GMT
 Visual Basic App using Foxpro DB vs Access DB vs SQL Server DB


Quote:

>I'm planning to create a VB application and am trying to figure out how
>to best store the DB.  The DB tables can have as much as 500,000 records
>in them and can be well over 100MB in size.

>Which DB format will work best with VB.  I want the queries to run
>quick.  Will storing the DB in Foxpro take advantage of FoxPro's
>Rushmore technology.  What about an SQL Server?

Sailesh,

We came across this problem not to long ago with 900,000+ records that have
to go on CD-ROM. Access is just too slow on pure many to many relational
queries.

What we discovered is a product called Codebase 6.0 by Sequiter software.

This database engine uses xBase (Foxpro, DBASE, Clipper [if anyone uses
clipper???]), with full ability to use production indexes.

Also it's fast and can handle a standard querie of 500,000 records in around
1 second.

To have a look at it go to http://www.sequiter.com/ and read the specs. Its
also only $495 for the complete thing (including a strange reporting program
and some good VBX controls), it includes the source code for the DLL as
well.

To see it in action get a copy of Corel's ALL MOVIE GUIDE or Symantec ACT
they both use it (thats where we found out about it actually by trying to
figure out \how corels quireis were so quick).

Grame Thompson
Alpharian Solutions - Australia
http://www.strata.net.au/users/alpharia



Tue, 12 Jan 1999 03:00:00 GMT
 Visual Basic App using Foxpro DB vs Access DB vs SQL Server DB

Quote:

>I'm planning to create a VB application and am trying to figure out how
>to best store the DB.  The DB tables can have as much as 500,000 records
>in them and can be well over 100MB in size.
>Which DB format will work best with VB.  I want the queries to run
>quick.  Will storing the DB in Foxpro take advantage of FoxPro's
>Rushmore technology.  What about an SQL Server?

The number of concurrent users is more of a factor than database
size when working with Access. If you're working with more than
about 2 dozen, you should probably consider SQL Server.

If you are thinking about a true client/server db, you're going
to have to take a hard look at cost factors as well. A SQL Server
implementation will require some high-performance server hardware
as well as fairly expensive server software, client access
licenses, etc. Also, its less likely to be something you can
install and walk away from unless the site already has a SQL
admin who can manage the server side. If these factors aren't an
issue, you might want to go to SQL Server from the beginning,
otherwise you could consider starting with VB/Access and
"upsizing" to SQL later.

Regarding FoxPro and Access, both now use Rushmore for query
optimization. (In fact, Rushmore is one of the reasons that MS
acquired FoxPro, as I understand it. The other was to get a "foot
in the door" for moving xBase developers to SQL Server.)

Joe

Never underestimate the power of a WAG.

http://www.citilink.com/~jgarrick



Fri, 15 Jan 1999 03:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Visual Basic App using Foxpro 2.6 DB

2. visual basic vs visual foxpro vs access

3. Importing data from Visual Foxpro DB into SQL Server DB

4. VISUAL BASIC VS. VISUAL FOXPRO VS. POWERBUILDER

5. SQL 6.5 DB Restoring vs SQL 7.0 DB Restoring

6. OLE DB vs ODBC for Oracle DB access

7. ODBC Vs ODBCDirect Vs ADO Vs OLE/DB advise

8. Opinions: VB vs. Access for DB apps

9. VB3.0 vs Access 2.0 vs Xbase db...

10. Access Vs. FoxPro (1.000.000 records DB)

11. The difference of SQL Server vs Access DB


 
Powered by phpBB® Forum Software