-
I've made a program which create a database
(1 .mdb file with 2 table and 12 fields).But
I noticed that it takes too much place since
it receive near 500 or 700 recordsets a day.
That makes 7Mo a day!!! obviously that is too
big. So, what are the constants or the methods or anything else I can do to lighten
the database in order to reach a ratio such
as 150 or 200 octets per recorset, given that
I do not need to sort the datas, it is only
a log on which I only apply SQL's requeries.
Nota: in a recordset, I sent 80/90 charaters,
and I am still using the old good JET database engine which is enough for me.
Thanks
-
If the file size is a problem, compact the database every day or two.
If network traffic and application speed is a problem (which it would be with a database of that size), consider moving to a real RDBMS (SQL server/oracle, etc)
You could keep a separate database that you append to each day (like an archive) and have the users start with an unpopulated database every day. That will help application speed, as long as you do not need to query on previous records in the archive.
HTH
Tom
