View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
05184 | Bug reports | Other | public | 2011-05-20 00:19 | 2011-06-01 23:43 |
Reporter | TMSWhite | Assigned To | c_schmitz | ||
Priority | low | Severity | minor | ||
Status | closed | Resolution | fixed | ||
Product Version | 1.91 | ||||
Fixed in Version | 1.91+ | ||||
Summary | 05184: unnecessary duplicate query - could slow down listing of surveys when there are many | ||||
Description | Lines 402-409 can be commented out in index.php, as they duplicate the query to list names of active instruments, and risk slow response if there are many active surveys (since this is called in a loop). The lines are: $result2 = db_execute_assoc("Select surveyls_title from ".db_table_name('surveys_languagesettings')." where surveyls_survey_id={$rows['sid']} and surveyls_language='$baselang'"); | ||||
Steps To Reproduce | validated that it generates correct listing when comment out these lines (but I don't yet know how to submit a patch). | ||||
Additional Information | If not commenting this out, perhaps the main query on the prior lines should be updated to have survey_language='$baselang' to avoid issuing multiple queries to the database. | ||||
Tags | No tags attached. | ||||
Bug heat | 2 | ||||
Complete LimeSurvey version number (& build) | 10103 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | |||||
Database type & version | Mysql | ||||
Server OS (if known) | Windows XP | ||||
Webserver software & version (if known) | Apache 2 | ||||
PHP Version | 5 | ||||
Date Modified | Username | Field | Change |
---|---|---|---|
2011-05-20 00:19 | TMSWhite | New Issue | |
2011-05-20 12:24 | c_schmitz | Assigned To | => c_schmitz |
2011-05-20 12:24 | c_schmitz | Status | new => assigned |
2011-05-28 18:43 | c_schmitz | Note Added: 15144 | |
2011-05-28 18:43 | c_schmitz | Status | assigned => resolved |
2011-05-28 18:43 | c_schmitz | Fixed in Version | => 1.91+ |
2011-05-28 18:43 | c_schmitz | Resolution | open => fixed |
2011-05-28 18:43 | c_schmitz | Note Added: 15145 | |
2011-06-01 23:43 | c_schmitz | Note Added: 15233 | |
2011-06-01 23:43 | c_schmitz | Status | resolved => closed |