Hi
Where do I start..
I have a database table that I am writing a perl script to update. The requirement is for me to load the table into memory and access it there, then when there are updates, update the in-memory table as well as a flat file and once an hour write those updates from the file to the DBMS database. DBD-RAM seems to be able to handle this well.
Now..
The updates will happen when an event occurs and a DIFFERENT script is triggered. I want to know if and how I can access the DBD-RAM table in memory from this new script. If not how can I do this.. This script needs to see if this event has already been logged into the RAM table and if so just update a counter or else just add it to the in-memory table as well as the disk file.
The basic challange is to be able to access the in-memory table from a seperate script.
Hope some-one can point me in the right direction..
Rgds
AcidHawk ----
Of All the things I've lost in my life it's my mind I miss the most.
Where do I start..
I have a database table that I am writing a perl script to update. The requirement is for me to load the table into memory and access it there, then when there are updates, update the in-memory table as well as a flat file and once an hour write those updates from the file to the DBMS database. DBD-RAM seems to be able to handle this well.
Now..
The updates will happen when an event occurs and a DIFFERENT script is triggered. I want to know if and how I can access the DBD-RAM table in memory from this new script. If not how can I do this.. This script needs to see if this event has already been logged into the RAM table and if so just update a counter or else just add it to the in-memory table as well as the disk file.
The basic challange is to be able to access the in-memory table from a seperate script.
Hope some-one can point me in the right direction..
Rgds
AcidHawk ----
Of All the things I've lost in my life it's my mind I miss the most.