meta user
network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 1 year, 5 months |
| seen | Mar 17 at 10:45 | |
| stats | profile views | 23 |
|
Feb 13 |
accepted | Tick boxes and Dropdown |
|
Feb 13 |
comment |
Tick boxes and Dropdown Second question: If multiple items have same options name and if I've rename the option name from the backend (eg: Donner to Donner Special) - I don't want all items that have same Option name to be replaced.. |
|
Feb 13 |
comment |
Tick boxes and Dropdown Thanks you very much for detailed response. Just two questions. items_extras and items_options_extras tables you have provided. I think you meant extra_id to be groups_id? |
|
Feb 13 |
revised |
Tick boxes and Dropdown added 152 characters in body |
|
Feb 13 |
revised |
Tick boxes and Dropdown added 3022 characters in body |
|
Feb 13 |
comment |
Tick boxes and Dropdown There is no need for boolean field. Check groups_extras_options result. It apply item to the group's (item to many group's) |
|
Feb 13 |
comment |
Tick boxes and Dropdown Still no reply?! |
|
Feb 12 |
asked | Tick boxes and Dropdown |
|
Dec 21 |
awarded | Supporter |
|
Dec 21 |
awarded | Scholar |
|
Dec 21 |
accepted | Improve `Update` performance (rows locking issue) |
|
Dec 21 |
comment |
Improve `Update` performance (rows locking issue) @Dtest wow!! thank you very much, updating performance is very fast now :) about 200 updates a second.. I followed your instruction and it work! :) I thought adding index on 'mobile' and 'status' would help the `UPDATE' to find the record quick but that was not the case hmmmmm. Thanks again. |
|
Dec 21 |
awarded | Student |
|
Dec 21 |
awarded | Commentator |
|
Dec 21 |
comment |
Improve `Update` performance (rows locking issue) Thanks I will read more updated advice now.. I've just dropped 'status' index and ran the scripts again - it did not improve the UPDATE performance.. still a lot of queues in the mysqladmin proc. I have just updated my question with iostat, please check if that causing problem? |
|
Dec 21 |
revised |
Improve `Update` performance (rows locking issue) added 936 characters in body |
|
Dec 21 |
comment |
Improve `Update` performance (rows locking issue) I am sorry, I meant status - yes I understand what Primary key does. |
|
Dec 21 |
comment |
Improve `Update` performance (rows locking issue) Would primary key take advantage over number ? |
|
Dec 21 |
revised |
Improve `Update` performance (rows locking issue) added 597 characters in body |
|
Dec 21 |
revised |
Improve `Update` performance (rows locking issue) added 10 characters in body |
