Re: Suggestoins for Local DB to use with Shareware
- From: "Ralf Mimoun" <nospam@xxxxxxxxx>
- Date: Sun, 30 Apr 2006 20:03:02 +0200
G. Bradley MacDonald wrote:
....
Sorry - I meant the add on for the DB - not my app. It is already in
the 10MB range. I just didn't want to have to have a 20+MB download
for the DB.
DBISAM "costs" some 100k.
....
All integrated db systems I know use their own tabkle components. InThat is a problem right there. It is becoming more and more important
DBISAM, it's TDBISAMTable (and TDBISAMQuery). I don't think that
there is anything working with Borlands TTable components.
for me not to have to use special components - as I want to use the
same code on the local DB as the larger DB - such as MS SQL, etc.
I forgot that you can use the Elevate ODBC driver to access the DBISAM database. That should do the trick.
The issue of having a default size of 4GB may be an issue. Even the
local database could grow quite large. For some customers - it would
be saving 200,000+ "records" each time - and each of those records
can be 3KB in size. I note that is says you can go up to 128GB which
should be fine - but it is a concern that is it not supported as the
default. Makes me wonder why.
Very simple: the maximum file size with Fat32 is 4 GB, so each file (.dat, ..idx and, if you use BLOB fields, .lbl) can't be larger. You can switch on large file support in no time for DBISAM, but having that as the default would be a sure cause of trouble. And, of course, you will need NTFS. Btw, 200k records * 3k is half a gigabyte, so no problem with the default settings.
What I really like: DBISAM is flexible. Really _flexible_. You can use the same application on an USB stick with no installation of anything, no DLL, nothing, and in a full C/S environment. Full multi user support. _Full_. You can access the same database on your local drive, via file access from another computer by LAN, via DB server on your machine, a DB server on another machine and ODBC. With as much users as you like or need, concurrently. You have all the methods and functions you need (eg. für backup, server access etc), and it simply fly as long as you have the indexes you need.
Ralf
.
- References:
- Suggestoins for Local DB to use with Shareware
- From: G . Bradley MacDonald
- Re: Suggestoins for Local DB to use with Shareware
- From: Ralf Mimoun
- Re: 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: Suggestoins for Local DB to use with Shareware
- Index(es):
Relevant Pages
|
