Some Clarifications
- From: G. Bradley MacDonald <bradley@xxxxxxxxxxxxxxxxxx>
- Date: Sun, 30 Apr 2006 09:47:27 -0700
Thanks to everyone for their replies. However, I think it would be good
to provide a little more information as to what I am trying to do.
I need or are concerned about the following
1. Performance of Insert statement. About 90% of what is done is
Inserts. And a lot of them! Hundreds of thousands of records in one
run. This is partially the reason I am looking to support DBs like
MSSQL - while they may not have the fastest Inserts - my customers run
them on BIG hardware and that makes a diff both in terms of speed - but
also supporting larger DBs.
2. Ability to support other languages. We sell to companies in
countries all over the world. So being able to support other Regional
Settings in Windows is important.
Anyone know how FireBird, NexusDB and DBISAM deal with that?
3. I am fine with a 1 to 2 MB addition to my download to support this
DB. I just don't want a 20+ MB download in addition to our software to
be able to deal with this.
4. The Indexes should be able to handle string fields of at least 256
in size. 512 would be preferrable. Total Index size of 600 would be
ideal.
5. MUST be able to access the DB using standard Delphi 6/7 controls.
Such as dbExpress? I do not want to write one set of code for the local
DB and then have to do it again for MS SQL.
Once again - any suggestions would be greatly appreciated!
--
G. Bradley MacDonald
bradley_AT_telus_DOT_net
.
- Follow-Ups:
- Re: Some Clarifications
- From: Wayne Niddery [TeamB]
- Re: Some Clarifications
- References:
- Suggestoins for Local DB to use with Shareware
- From: G . Bradley MacDonald
- Suggestoins for Local DB to use with Shareware
- Prev by Date: Re: Suggestoins for Local DB to use with Shareware
- Next by Date: Re: dcc64.exe
- Previous by thread: Re: Suggestoins for Local DB to use with Shareware
- Next by thread: Re: Some Clarifications
- Index(es):
Relevant Pages
|