View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000540 | Composr | [All Projects] General / Uncategorised | public | 2012-05-29 12:03 | 2012-05-29 12:03 |
| Reporter | Chris Graham | Assigned To | Chris Graham | ||
| Severity | Minor-bug | ||||
| Status | resolved | Resolution | fixed | ||
| Product Version | |||||
| Fixed in Version | |||||
| Summary | 0000540: Catalogues use lots of queries | ||||
| Description | Each field in a catalogue requires a database lookup. Optimise it using 'UNION' if the MySQL version supports it. | ||||
| Tags | No tags attached. | ||||
| Time estimation (hours) | |||||
| Sponsorship open | |||||
|
|
Fixed in git commit 0339d98 (https://github.com/chrisgraham/Composr/commit/0339d98 - link will become active once code pushed) A hotfix (a TAR of files to upload) have been uploaded to this issue. These files are made to the latest intra-version state (i.e. may roll in earlier fixes too if made to the same files) - so only upload files newer than what you have already. Always take backups of files you are replacing or keep a copy of the manual installer for your version, and only apply fixes you need. These hotfixes are not necessarily reliable or well supported. Not sure how to extract TAR files to your Windows computer? Try 7-zip (http://www.7-zip.org/). hotfix-540, 2012-05-29 12pm.tar (61,440 bytes) |
|
|
Automated response: Allow further optimisation By putting... :set_value('catalogue_limit_cat_field_load__<cataloguename>','1'); into Commandr, don't load fields that don't show on category views. This limits templating possibilities, but improves performance. |
|
|
Fixed in git commit 3309462 (https://github.com/chrisgraham/Composr/commit/3309462 - link will become active once code pushed) A hotfix (a TAR of files to upload) have been uploaded to this issue. These files are made to the latest intra-version state (i.e. may roll in earlier fixes too if made to the same files) - so only upload files newer than what you have already. Always take backups of files you are replacing or keep a copy of the manual installer for your version, and only apply fixes you need. These hotfixes are not necessarily reliable or well supported. Not sure how to extract TAR files to your Windows computer? Try 7-zip (http://www.7-zip.org/). hotfix-540, 2012-05-29 1pm.tar (61,440 bytes) |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2023-02-26 18:29 | Chris Graham | Category | General => General / Uncategorised |
