/
Optimization of TableFound function

Optimization of TableFound function

Owned by Alex
Last updated: Feb 11, 2013Version comment

Imported From: http://groups.google.com/group/in-portal-dev/browse_thread/thread/4a36284a55d59372#

Class kDBConnection has TableFound function, that does "SHOW TABLES LIKE TableName" each time it is called with a new table name.

There are 2 ways of improving it:

  1. get list of all tables on first function call and then do in_array on every repeated call
  2. get list of all tables during unit config cache rebuild and save it into file (save 1 db query on each function call) and then only open that file and search for needed table.

Related Tasks

Error rendering macro 'jira' : Unable to locate Jira server for this macro. It may be due to Application Link configuration.