Re: Cached Queries Problem

[prev] [thread] [next] [Date index for 2005/04/28]

David Christensen said:
>> Have you determined where the name dbdpg_13 comes from?  That might be
>> a clue.
>
> I believe it would be the 13th query that DBD::Pg has cached thus far.

What I'm suggesting is that the code which generates that name may be
where  the caching problem is, so finding it would be useful.

> One thing that I am doing is trying to preload my Class::DBI subclass
> in apache (just via a use statement). I'm using one of the table-setup
> utility functions rather than hard-coding the fields in, so that may be
> the cause of the problem -- we obviously have to query the database
> before we can pull info out of the system tables.

This should be safe if you are using my mod_perl code from the wiki that
overrides db_Main().  You can check by turning on debugging for
Apache::DBI.  You should see warnings about skipping the cache during
server startup.

- Perrin