Cache queries to maximize performance

Registered by Lars Vierbergen

There are too much identical queries send by MySQLfs when showing a directory listing in admin.php, just for an empty root directory 11(!) identical queries are send.

Blueprint information

Status:
Started
Approver:
None
Priority:
Medium
Drafter:
None
Direction:
Approved
Assignee:
Lars Vierbergen
Definition:
Approved
Series goal:
None
Implementation:
Blocked
Milestone target:
None
Started by
Lars Vierbergen

Related branches

Sprints

Whiteboard

Dump of queries:
empty directory /:
---
SELECT * FROM `index` WHERE `path`='' AND `filename` = ''
SELECT * FROM `index` WHERE `path`='' AND `filename` = ''
SELECT * FROM `index` WHERE `path`='' AND `filename` = ''
SELECT * FROM `index` WHERE `path`='' AND `filename` = ''
SELECT * FROM `index` WHERE `path`='' AND `filename` = ''
SELECT * FROM `index` WHERE `path`='' AND `filename` = ''
SELECT * FROM `index` WHERE `path`='' AND `filename` = ''
SELECT * FROM `index` WHERE `path`='' AND `filename` = ''
SELECT * FROM `index` WHERE `path`='' AND `filename` = ''
SELECT * FROM `index` WHERE `path` = '' AND `filename`!=''
SELECT * FROM `index` WHERE `path`='' AND `filename` = ''
SELECT * FROM `index` WHERE `path`='' AND `filename` = ''
---
Directory / with two directories:
---
SELECT * FROM `index` WHERE `path`='' AND `filename` = ''
SELECT * FROM `index` WHERE `path`='' AND `filename` = ''
SELECT * FROM `index` WHERE `path`='' AND `filename` = ''
SELECT * FROM `index` WHERE `path`='' AND `filename` = ''
SELECT * FROM `index` WHERE `path`='' AND `filename` = ''
SELECT * FROM `index` WHERE `path`='' AND `filename` = ''
SELECT * FROM `index` WHERE `path`='' AND `filename` = ''
SELECT * FROM `index` WHERE `path`='' AND `filename` = ''
SELECT * FROM `index` WHERE `path`='' AND `filename` = ''
SELECT * FROM `index` WHERE `path` = '' AND `filename`!=''
SELECT * FROM `index` WHERE `path`='' AND `filename` = ''
SELECT * FROM `index` WHERE `path`='' AND `filename` = ''
SELECT * FROM `index` WHERE `path`='' AND `filename` = 'etc'
SELECT * FROM `index` WHERE `path`='' AND `filename` = 'etc'
SELECT * FROM `index` WHERE `path`='' AND `filename` = 'etc'
SELECT * FROM `index` WHERE `path`='' AND `filename` = 'home'
SELECT * FROM `index` WHERE `path`='' AND `filename` = 'home'
SELECT * FROM `index` WHERE `path`='' AND `filename` = 'home'
---
empty directory /etc/ftpd :
SELECT * FROM `index` WHERE `path`='etc' AND `filename` = 'ftpd'
SELECT * FROM `index` WHERE `path`='etc' AND `filename` = 'ftpd'
SELECT * FROM `index` WHERE `path`='etc' AND `filename` = 'ftpd'
SELECT * FROM `index` WHERE `path`='etc' AND `filename` = 'ftpd'
SELECT * FROM `index` WHERE `path`='etc' AND `filename` = 'ftpd'
SELECT * FROM `index` WHERE `path`='etc' AND `filename` = 'ftpd'
SELECT * FROM `index` WHERE `path`='etc' AND `filename` = 'ftpd'
SELECT * FROM `index` WHERE `path` = 'etc/ftpd' AND `filename`!=''
SELECT * FROM `index` WHERE `path`='' AND `filename` = 'etc'
SELECT * FROM `index` WHERE `path`='etc' AND `filename` = 'ftpd'

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.