Re: Table caching

2005-06-23 Thread Dan Nelson
In the last episode (Jun 22), Peter Hicks said: > I have a relatively simple table of 200+ network devices and 60+ > sites. This is accessed about 30 times a minute by various perl > scripts to pick up device/site information. > > Will I see any noticable benefit from creating a cached copy of th

Table caching

2005-06-23 Thread Peter Hicks
Hello I have a relatively simple table of 200+ network devices and 60+ sites. This is accessed about 30 times a minute by various perl scripts to pick up device/site information. Will I see any noticable benefit from creating a cached copy of this table as a MEMORY table? The data doesn't