Cache queries to maximize performance
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
- Completed by
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'