View Issue Details

IDProjectCategoryView StatusLast Update
0023395mantisbtdb oraclepublic2019-01-07 13:01
Reportercproensa Assigned Tocproensa  
PrioritynormalSeverityminorReproducibilityhave not tried
Status closedResolutionfixed 
Product Version2.7.0 
Target Version2.7.0Fixed in Version2.7.0 
Summary0023395: Performance issue reading config table with oracle database
Description

For every page executed, config table is fully read and cached.
When using Oracle database, ADOdb maps columnt type "L" to "clob" type, and reading clob fields is significantly slower that standard char fields.

This causes a very noticeable delay on every page load.
For example, with 500 rows in config table:

  • reading values as clob, with standard "select *" query from config_api, it takes about 3-4 secs
  • reading values as varchar, it takes 0.03 secs
TagsNo tags attached.

Relationships

related to 0025167 assignedcproensa Performance issue reading project table with oracle database 

Activities

Related Changesets

MantisBT: master 1b1f2b2c

2017-09-21 16:01

cproensa

Committer: dregad


Details Diff
Oracle, read config values as varchar

When using Oracle database, read config values as varchar type whenever
it's possible, to avoid performance issues of reading clob field types.

Even if the issue may also exist with other tables, config table is
especially sensitive, as it is fully fetched for every page execution.

Fixes: 0023395
Affected Issues
0023395
mod - core/config_api.php Diff File