Hello, In an attempt to offload SELECT queries from our database and decrease the time spent gathering data, we have begun to aggressively cache data in users' sessions (StateDB=MLDBM::Sync::SDBM_File, StateSerializer=Data::Dumper). Unfortunately, when the data set is too large the process of reading/thawing the data becomes painfully slow. Switching to DB_File didn't seem to help. We haven't tried Storable but my inclination is that it wouldn't make that much of a difference. The session files are on the order of a 100k.
1) Is the thawing of the data to blame? 2) How might we speed this process up or are we heading down a blind alley? 3) Lastly, I have heard good things about IPC:MM (fastest gun in the west when it comes to using Shared memory for a cache). Could this be used instead of MLDBM::Sync::SDBM_File? Any hints or help would be appreciated! Christian --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
