>I NEED AMMO!!!

Here's some ammo. Keep in mind that Access uses the Jet database engine. VFP has its own engine..
Below is an email dialogue between myself and a company that does VB/VFP/VC++ development.

Date: Sun, 31 Aug 1997 12:01:23 -0700
From: Russell Sturm
To: "'Mark S. Frank'"
Subject: RE: Visual Foxpro vs VB/Jet 3.5

There is no comparison between the access speeds of VFP and VB. VFP is
lightyears faster on every operation, even with largest data sets and VB using
the fastest RDO statements. The only reason we program in VB/ODBC is because
some of our clients are a little uncomfortable with VFP and prefer a more
"mainstream" solution such as VB/SQL-Server.

Russell Sturm
Senior Software Engineer
VisualSoft, Inc.

-----Original Message-----
From: Mark S. Frank [SMTP:msf@satexas.com]
Sent: Saturday, August 30, 1997 11:10 PM
To: visualinc@earthlink.ne
Subject: Visual Foxpro vs VB/Jet 3.5

Hi VisualSoft,

I appreciate your combined expertise in both VFP and VB. If possible, I
would like to pass a question by your engineers that has been very
difficult for me to answer.

When you compare VFP's database engine against Jet 3.5, which
one is superior in terms of performance and flexibility? In particular, I
need to know the power/speed of Jet insofar as its ability to handle fast
lookups on indexed multi-million record files, its ability to support
programmatic creation, manipulation, and discarding of innumerable
temporary read/write tables, and also its ability to provide very flexible,
near instantaneous manipulations of multiple, interrelated tables that
might have between 1000 and 100,000 records each.

I know from personal experience that VFP excels here. But can Jet 3.5
equally support these kinds of operations, and do it really fast?

Thanks very much!!!
- Mark S. Frank
msf@satexas.com