View Issue Details

Jump to NotesJump to History
This issue affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
07900Bug reportsSurvey takingpublic2013-06-01 23:172013-06-14 14:27
Reportermlhess Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionwon't fix 
Summary07900: add indexes to tokens_SID and survey_SID tables when created
Description

We have a install with over 300,000 tokens and 250,000 taken surveys. We have to add the indexes by a hand. Please add indexes so that queries don't slow down.

Additional Information

The build number is wrong below. I have done a checkout of 2.05 from git.

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)130424
I will donate to the project if issue is resolvedNo
Browser
Database type & versionmysql
Server OS (if known)linux
Webserver software & version (if known)apache
PHP Version5.4
Git branch / Pull Request URL

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2013-06-02 10:36

administrator   ~25443

What indexes are you missing?
mlhess

mlhess

2013-06-02 15:00

reporter   ~25445

In looking at in more detail, at some point they were not added. We have added a create index on survey_SID token (token). Can we have the upgrade script create this?
c_schmitz

c_schmitz

2013-06-14 14:26

administrator   ~25527

I am sorry but we won't create a separate DB version for a simple fix like that.

Any DBA should be able to create a script for all token tables that adds missing indexes. Anyway, it is not a bug of LimeSurvey, at least not anymore.
c_schmitz

c_schmitz

2013-06-14 14:27

administrator   ~25528

This should give you a start:
http://stackoverflow.com/questions/10066783/in-mysql-how-do-i-batch-rename-tables-within-a-database

Issue History

Date Modified Username Field Change
2013-06-01 23:17 mlhess New Issue
2013-06-02 10:36 c_schmitz Note Added: 25443
2013-06-02 10:36 c_schmitz Assigned To => c_schmitz
2013-06-02 10:36 c_schmitz Status new => feedback
2013-06-02 15:00 mlhess Note Added: 25445
2013-06-02 15:00 mlhess Status feedback => assigned
2013-06-14 14:26 c_schmitz Note Added: 25527
2013-06-14 14:26 c_schmitz Status assigned => closed
2013-06-14 14:26 c_schmitz Resolution open => won't fix
2013-06-14 14:27 c_schmitz Note Added: 25528