caching data in a module

[Daniel McBrearty]

Hi all

I have some multilingual pages running on mysql/modperl.

I'm thinking that certain text will be retrieved again and again from the db, hence I'm thinking about caching it in a hash. There is alreaday a specific method I get that retrieves these values so just a rewrite of that method would do it. It should give a good speed improvement as those values probably make up about 80 pc or so of queries.

I'm thinking of initialising the hash in startup.pl, with an init method I'd put there.

Problem is this : I'd like the data to be shared across processes. I understand from reading

http://perl.apache.org/docs/1.0/guide/performance.html#How_Shared_Is_My_Memory_

that any memory that gets written to will be seen as dirty, and therefore not shared. But if it is only written to at startup, will that still apply?

Anyone know?

thanks

Daniel



--
Daniel McBrearty
email : danielmcbrearty at gmail.com
www.engoi.com : the multi - language vocab trainer
BTW : 0873928131