caching in Mantis

patren · Post by **patren** » 10 Aug 2006, 04:37

Hello,
I inherited the job of looking after a Mantis installation (is now 1.0.5), and they have been some grumbles about performance.I turned on the config options to look at the queries against the db. There are some which are repetitive like: SELECT * FROM mantis_user_table WHERE user_id='183'.

But if I read the code correctly (user_api.php in this case) a row of data like this should be cached in a variable and not need a db query. I added debug and the global cache variable is not set in this case. A page refresh and the same queries are done again.

Is my understanding not right, or do we have a configuration problem somewhere. [php 5.1.4 on Ubuntu Linux]

Thanks,
Pat

patren · Post by **patren** » 14 Aug 2006, 06:15

Any ideas?

Post by **vboctor** » 15 Aug 2006, 05:47

The cached data is kept for the lifetime of one page request. We don't support sessions where we keep data for the whole session.

Regards,
Victor
http://www.futureware.biz/mantisconnect/

gravyface · Post by **gravyface** » 18 Aug 2006, 03:01

You can also enable $g_use_persistent_connections in config_inc.php, but this depends if it's the connection itself that's expensive (perhaps you're running MySQL on a different server across a busy network?) or if there are alot of concurrent users, etc.

for more info on db conn persistence in PHP:
http://www.phpfreaks.com/phpmanual/page ... tions.html