Looking for a database engine 
Author Message
 Looking for a database engine

Hi,

One of our customers is about to embark on a new development project in
which a small database driven tool will be distributed to several
dealers, countrywide.
The development tool will most likely be VB, but the question is what
database engine to use.
Apart from the fact that the database must be royalty free, the most
important aspect is reliability. The database should handle
approximately 2 million records, and the application is designed to
serve a single user, with the potential of adding maybe 2 more.
Currently we are considering Jet and FoxPro.

Thanks,
Eliezer Birinbom

Sent via Deja.com http://www.***.com/
Share what you know. Learn what you don't.



Sat, 19 Jan 2002 03:00:00 GMT
 Looking for a database engine

Hi Eliezer,

I can tell you from years of experience developing FoxPro apps, that the
Foxpro database works fine with 2 million records.  From what I read in
these newsgroups, Jet may not be quite up to the task.

I'll be interested to see what some of the Jet experts have to say -- the
information will be useful to me also.

Regards,
David Chazin

----------------------------------------------------------------------------

Quote:

>Hi,

>One of our customers is about to embark on a new development project in
>which a small database driven tool will be distributed to several
>dealers, countrywide.
>The development tool will most likely be VB, but the question is what
>database engine to use.
>Apart from the fact that the database must be royalty free, the most
>important aspect is reliability. The database should handle
>approximately 2 million records, and the application is designed to
>serve a single user, with the potential of adding maybe 2 more.
>Currently we are considering Jet and FoxPro.

>Thanks,
>Eliezer Birinbom

>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.



Sat, 19 Jan 2002 03:00:00 GMT
 Looking for a database engine
For 2 million records, if your only options are Jet and FoxPro, I'd probably
go with FoxPro (although I *hate* working with FoxPro -- but it's probably
better suited for the volume).  On big nuisance working with FoxPro using a
VB front end is the fact that you cannot "pack" the database from VB.  The
only way to do it (that I've found) is to write a mini-program in FoxPro to
pack the database (and make sure it allows you to send it the path of the
database at runtime), compile it, and call it from your VB app using a shell
command.  *very* annoying.  Hmm...you know...there really *should* be an
ActiveX control out there that could do this for you.  If there isn't, there
sure AUGHT TO be!

However, if you're willing to consider a third alternative, look into the
new MSDE engine.  It's a scaled down version of the SQL 7.0 engine, royalty
free, and optimized for up to 5 concurrent users.  You'll get the benefits
of using a SQL engine without the cost.

Manish

Quote:

> Hi,

> One of our customers is about to embark on a new development project in
> which a small database driven tool will be distributed to several
> dealers, countrywide.
> The development tool will most likely be VB, but the question is what
> database engine to use.
> Apart from the fact that the database must be royalty free, the most
> important aspect is reliability. The database should handle
> approximately 2 million records, and the application is designed to
> serve a single user, with the potential of adding maybe 2 more.
> Currently we are considering Jet and FoxPro.

> Thanks,
> Eliezer Birinbom

> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.



Sat, 19 Jan 2002 03:00:00 GMT
 Looking for a database engine
Quote:

> Hi,

> One of our customers is about to embark on a new development project in
> which a small database driven tool will be distributed to several
> dealers, countrywide.
> The development tool will most likely be VB, but the question is what
> database engine to use.
> Apart from the fact that the database must be royalty free, the most
> important aspect is reliability. The database should handle
> approximately 2 million records, and the application is designed to
> serve a single user, with the potential of adding maybe 2 more.
> Currently we are considering Jet and FoxPro.

> Thanks,
> Eliezer Birinbom

There is also MSDE ("small" version of SQL 7.0, royalty free for users
Visual Studio etc).
I think (not sure) that it could handle much more than 2 milion record. And
it is an "realy" SQL engine.
You could dowlnoad MSDE form MS site.


Mon, 21 Jan 2002 03:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Looking for a database engine

2. Looking for good database engine for legal specific practice management product

3. Looking for database engine.

4. Looking for Delphi compatable database engines

5. Looking for database engine

6. Looking for database engine.

7. Looking for old version database engine ...

8. Paradox Engine -> Database Engine

9. Looking for a DB engine

10. Looking for WorkFlow Engine with Oracle

11. Looking for Freeware or Licensed Shareware Btrieve engine


 
Powered by phpBB® Forum Software