Possible with EO?
Possible with EO?
- Subject: Possible with EO?
- From: Lotsa Cabo <email@hidden>
- Date: Wed, 7 Jul 2004 14:22:13 -0400
Remember, I'm from a M$/SQL2K environment, so please be gentle...
Is it possible to groom off older objects within a database using EO?
A little history...
In many of my larger M$/SQL applications, I have manually handled data
migration and archiving of old data. Generally speaking, here is how
it worked:
ISSUING OF OBJECT IDS:
========================
1. A table called "tblObjectID" is created with the following columns:
row_id int(4) identity ... essentially, and auto-incrementing number
object_name char(25) ... the name of the object being tracked
last_id int(4) ... the last ID for the object dolled to the
application
archive_id int(4) ... all objects below this ID are in a warehouse
database
2. One row exists, in the tblObjectID table, for each object in the
application;
3. All of my application's code uses stored procedures for all
database activities;
4. During an INSERT, the proc calls another proc "sp_getNextID" and
passes in the object name, the "sp_getNextID" then increments the
stored ID and returns the new integer.
ARCHIVING PROCESS:
========================
1. Each night, at 11:59 PM, a DTS package determines the oldest age of
each object type in the application;
2. All objects that have been inserted or updated, since the last time
this process executed, are then copied to a secondary database on
another server;
3. The highest ID of each object is stored back into the "tblObjectID"
under the "archive_id" column; and,
4. All objects that have been copied to the secondary database are
then removed from the primary database.
This process, as archaic as it sounds, has successfully allowed me to
move more intensive processed off to a secondary server and still have
a backup incase something goes down with the primary copy.
Is something like this possible with EO?
Thanx,
Ryan
_________________________
Tired of spam? Signup for a FREE SpamJammer.Com account and say
goodbye to junk email forever!
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.