Memory and performance problem with big (>30,000+ pubs) Aigaion database

[kristiank]

Aigaion keeps every publication's pub_id and bibtex_id stored in a session cache variable for later crossreferencing needs (helpers/bibtex.php). Instead of keeping everything in a cached variable, it would be better to use database queries.

For memory it would be better, because the bigger your database is, the more memory it will require (and reach PHP's memory_limit, by default 128 MiB).

For performance it would be much better, because there would be no need for looping through all the tens of thousands of publication rows stored in Aigaion (nor to send this data between MySQL and PHP) every time any single publication is added/updated/deleted.