- Posts: 10099
- Thank you received: 3589
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
warning-database crashed-user read it
- tpartner
- Topic Author
- Offline
- LimeSurvey Community Team
Less
More
8 years 11 months ago #120470
by tpartner
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
warning-database crashed-user read it was created by tpartner
I think that rather than just making loud, sometimes irrelevant statements, you should focus on your survey designs, not the perceived limitations of the platform.
If you think you can improve LS, you are welcome to submit pull requests.
If you think you can improve LS, you are welcome to submit pull requests.
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The following user(s) said Thank You: DenisChenu, holch, Ben_V, Bigred01
The topic has been locked.
- robertk01
- Offline
- New Member
Less
More
- Posts: 1
- Thank you received: 0
8 years 11 months ago #120491
by robertk01
Replied by robertk01 on topic warning-database crashed-user read it
If this is perceived, should take care of innocent user, remind first and fix the bug ASAP.
Just in my eyes, this guy(girl?) help to find a bug, your brashness say no to those developer help.
vest of a loyal user from 1.9
Just in my eyes, this guy(girl?) help to find a bug, your brashness say no to those developer help.
vest of a loyal user from 1.9
The topic has been locked.
- Ben_V
- Offline
- Platinum Member
Less
More
- Posts: 1128
- Thank you received: 329
8 years 11 months ago - 8 years 11 months ago #120494
by Ben_V
Benoît
EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
Last Releases => 2.6x.x goo.gl/ztWfIV | 2.06/2.6.x => bit.ly/1Qv44A1
Demo Surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)
Replied by Ben_V on topic warning-database crashed-user read it
Welcome Robert(k),
I assume you've around 5 years experience with LimeSurvey without any major encountered issue, if you are a "loyal user from 1.9" and if this is your 1st participation in this active forum where problems are usually discussed and solved… This sounds very good and it will be particularly valuable for all the LimeSurvey community (developers & users) if you can (in a few words) describe how you are using the software (context/purpose) & your personal overall opinion (pro & cons) ?
I assume you've around 5 years experience with LimeSurvey without any major encountered issue, if you are a "loyal user from 1.9" and if this is your 1st participation in this active forum where problems are usually discussed and solved… This sounds very good and it will be particularly valuable for all the LimeSurvey community (developers & users) if you can (in a few words) describe how you are using the software (context/purpose) & your personal overall opinion (pro & cons) ?
Benoît
EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
Last Releases => 2.6x.x goo.gl/ztWfIV | 2.06/2.6.x => bit.ly/1Qv44A1
Demo Surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)
Last edit: 8 years 11 months ago by Ben_V.
The following user(s) said Thank You: holch
The topic has been locked.
- holch
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 11639
- Thank you received: 2737
8 years 11 months ago #120504
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic warning-database crashed-user read it
I am also asking myself how someone wants to create a database design that DOESN'T use one column per question. I am not a database expert, but I would love to hear how this could be improved. Would be very interesting. Maybe one of those database experts could explain this in detail.
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
The topic has been locked.
- jelo
- Offline
- Platinum Member
Less
More
- Posts: 5033
- Thank you received: 1257
8 years 11 months ago #120508
by jelo
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
Replied by jelo on topic warning-database crashed-user read it
Since iscar has posted in
this thread
that he has changed from Limesurvey to another tool, you might no longer get an answer from iscar.
1.) A warning is not that simple, since different database servers are coming up with different limits. No simple rule of thumb or easy checking.
It isn't a big issue if you backup your surveys. I wonder what kind of surveys are designed.
Before they reach the limit they will get slow. The main purpose of LimeSurvey is asking questions in form of a survey. Sometimes it look that they want to design a data input tool with very big array questions and other things which would raise the dropout rate in a typical survey situation up to 100%.
There is always room to improve the database model.
2.) If there is room for a database design discussion take a look at
stackoverflow.com/questions/1764435/data...-design-for-a-survey
manual.limesurvey.org/Database_Storage_E...t_M1_Database_Design
1.) A warning is not that simple, since different database servers are coming up with different limits. No simple rule of thumb or easy checking.
It isn't a big issue if you backup your surveys. I wonder what kind of surveys are designed.
Before they reach the limit they will get slow. The main purpose of LimeSurvey is asking questions in form of a survey. Sometimes it look that they want to design a data input tool with very big array questions and other things which would raise the dropout rate in a typical survey situation up to 100%.
There is always room to improve the database model.
2.) If there is room for a database design discussion take a look at
stackoverflow.com/questions/1764435/data...-design-for-a-survey
manual.limesurvey.org/Database_Storage_E...t_M1_Database_Design
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The topic has been locked.
- misys
- Offline
- New Member
Less
More
- Posts: 1
- Thank you received: 0
8 years 11 months ago #120546
by misys
Replied by misys on topic warning-database crashed-user read it
I Closed your post in SO, had been entertained.
1.read it first, How number of columns affects performance?
2.When tables get too many columns,technically speaking, it's a design flaw.
Even limit is 4096,it's seldom to see a table columns>60.no engineer would like to design wide table.
It absolutely cause performance problem, and many unpredictable issues even crash. Cases I experienced such as backup database but it contain inconsistent data.
3.
when create those wide facts table, always "vertical split" wide table to several thin tables with the same primary key-id.
Normally revise 3 places:
Try it, 30mins code work.
Btw, users reminder is always been appreciated.
1.read it first, How number of columns affects performance?
2.When tables get too many columns,technically speaking, it's a design flaw.
Even limit is 4096,it's seldom to see a table columns>60.no engineer would like to design wide table.
It absolutely cause performance problem, and many unpredictable issues even crash. Cases I experienced such as backup database but it contain inconsistent data.
3.
when create those wide facts table, always "vertical split" wide table to several thin tables with the same primary key-id.
Normally revise 3 places:
Code:
// table_1 include column1-100, table_2 include column101-200 for($i=0; $i<=100; $i++) { CREATE table_n(column1,column2,…column100 //switch tables or get _n from another individual table switch ($column_n) { case $column_n > 100 && $column_n <= 200: $table_n = 'table_1'; break; case $column_n > 200 && $column_n <= 300 : $table_n = 'table_2'; ... //join query If you select * select * from table_1 inner join table_2
Btw, users reminder is always been appreciated.
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13597
- Thank you received: 2487
8 years 11 months ago #120595
by DenisChenu
You can patch the next Major LimeSurvey release, Sam is worjing on it, and we need help to get quick. github.com/SamMousa/LimeSurvey
Remind :
- need to work on more SQL the mySQL only
- need to be easily updatable (when we all our old user's update 1.90 version for example)
- need to be maintainable
We have a project to do big optimisation on SQL table, need some times. Maybe if we sell LimeSurvey a lot of money ....
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic warning-database crashed-user read it
Hi,misys wrote: ....
Try it, 30mins code work.
Btw, users reminder is always been appreciated.
You can patch the next Major LimeSurvey release, Sam is worjing on it, and we need help to get quick. github.com/SamMousa/LimeSurvey
Remind :
- need to work on more SQL the mySQL only
- need to be easily updatable (when we all our old user's update 1.90 version for example)
- need to be maintainable
We have a project to do big optimisation on SQL table, need some times. Maybe if we sell LimeSurvey a lot of money ....
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
- holch
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 11639
- Thank you received: 2737
8 years 11 months ago #120597
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic warning-database crashed-user read it
@misys: How much is your hourly rate? If this really is just 30min code work, I guess I could sponsor this feature. Not that I need it much, but I ran in the database column limit once, with a survey that had loads of multiple answer questions, with long answer lists. So it would be interesting.
I am sure that the limesurvey developers wouldn't mind implementing this in 2.06 if we could get this running in the next 2 weeks (any feedback on that?).
Could you let me know when you would be able work on this and what the total cost would be for this?
I am sure that the limesurvey developers wouldn't mind implementing this in 2.06 if we could get this running in the next 2 weeks (any feedback on that?).
Could you let me know when you would be able work on this and what the total cost would be for this?
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
The topic has been locked.
- jelo
- Offline
- Platinum Member
Less
More
- Posts: 5033
- Thank you received: 1257
8 years 11 months ago #120599
by jelo
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
Replied by jelo on topic warning-database crashed-user read it
Since iscar, robertk and misys are one person I wouldn't expect too much interaction.
But let me quote DenisChenu who once told me about problematic Wordpress plugins: "use a plugin make by a good dev".
Transfer that remark to survey systems and you have nothing to fear.
But let me quote DenisChenu who once told me about problematic Wordpress plugins: "use a plugin make by a good dev".
Transfer that remark to survey systems and you have nothing to fear.
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The topic has been locked.
- misys2
- Offline
- New Member
Less
More
- Posts: 3
- Thank you received: 0
8 years 10 months ago #120819
by misys2
I am willing to help you.
It's quick to paste the vertical split paradigm.Since I never engaged in this project, most of time spend on reading the original code.
I skimmed through the 2.05 version last weekend, have no experience on the 1.90 version.
It's bold idea that maintain multi subversions at the same time. I guess 1.90 version has something special thus still been maintained. I suggest to pack the files need to be revised of each subversion.
Btw, based on my understanding, update script always based on the latest version. It's easy to find the update problem and minimize the update script.
Replied by misys2 on topic warning-database crashed-user read it
Hi,DenisChenu wrote:
Hi,misys wrote: ....
Try it, 30mins code work.
Btw, users reminder is always been appreciated.
You can patch the next Major LimeSurvey release, Sam is worjing on it, and we need help to get quick. github.com/SamMousa/LimeSurvey
Remind :
- need to work on more SQL the mySQL only
- need to be easily updatable (when we all our old user's update 1.90 version for example)
- need to be maintainable
We have a project to do big optimisation on SQL table, need some times. Maybe if we sell LimeSurvey a lot of money ....
I am willing to help you.
It's quick to paste the vertical split paradigm.Since I never engaged in this project, most of time spend on reading the original code.
I skimmed through the 2.05 version last weekend, have no experience on the 1.90 version.
It's bold idea that maintain multi subversions at the same time. I guess 1.90 version has something special thus still been maintained. I suggest to pack the files need to be revised of each subversion.
Btw, based on my understanding, update script always based on the latest version. It's easy to find the update problem and minimize the update script.
The topic has been locked.
- misys2
- Offline
- New Member
Less
More
- Posts: 3
- Thank you received: 0
8 years 10 months ago #120820
by misys2
Replied by misys2 on topic warning-database crashed-user read it
@holch, I am misys, cannot login that account.
Pls pack the files need to be revised with your requirement, my mail:misys linuxmail.org
I think you are the leader of this project, but your speaking smell weird and it seemed you know little about database. I am not sure your authenticity.
Btw, freelancer.com is open for you.
Pls pack the files need to be revised with your requirement, my mail:misys linuxmail.org
I think you are the leader of this project, but your speaking smell weird and it seemed you know little about database. I am not sure your authenticity.
Btw, freelancer.com is open for you.
The topic has been locked.
- misys2
- Offline
- New Member
Less
More
- Posts: 3
- Thank you received: 0
8 years 10 months ago #120821
by misys2
Replied by misys2 on topic warning-database crashed-user read it
Uhhh, dunnt understand what you said.
If any further question, please mail me.
If any further question, please mail me.
The topic has been locked.