I have considered this, but until I get a better idea of table size
and the approx number of records in each I won't know which tables should or
should not be opened this way. But I believe most of the tables that would
get larger enough to be any problem were they loaded into memory are also
those in which speed isn't quite as important.
One can set the ABS tables as in-memory, so I thought about creating
all the original tables with their built-in, page encryption so that I don't
have some of the problems come up that we've talked about here, and then
create separate clones of those tables where access speed is really
important. Store changes in the in-memory tables first and then Post them to
the normal tables immediately afterwards...resulting in immediate write of
the encrypted page. But you're suggestion seems a bit cleaner, plus I'd
still only require one table per a specific set of data! Thanx!
That's why I love this list! Someone is always bound to come up
with a simple idea I hadn't thought of!
from Robert Meek dba "Tangentals Design"
e-mail: [EMAIL PROTECTED]
Freelance Windows Programming for XP and Vista
Also proud to be a Moderator of the "Delphi-List" at elists.org
"Reality cannot be explained...only enjoyed or endured as your current
perspective allows!"
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Brian
Sent: Sunday, October 07, 2007 6:30 AM
To: 'Delphi-Talk Discussion List'
Subject: RE: Creating new solutions
As an option ...
If the DB is not written to very often but read frequently, you can
Create a inherited DB component which ...
On 'open', will read the entire "encrypted" DB into an in-memory
"non-encryted" DB.
On 'AfterPost' of the in-memory DB, includes a shadow write to the disk DB
(encrypting on the way).
(plus any other 'modified' methods as required)
This way, once loaded, the application will be very fast but the disk based
data is maintained and is still encrypted
Regards,
Brian
__________________________________________________
Delphi-Talk mailing list -> Delphi-Talk@elists.org
http://www.elists.org/mailman/listinfo/delphi-talk
__________________________________________________
Delphi-Talk mailing list -> Delphi-Talk@elists.org
http://www.elists.org/mailman/listinfo/delphi-talk
