194 reputation
9
bio website
location
age
visits member for 2 years, 10 months
seen Oct 7 at 16:31

Feb
15
accepted Generating Invoices and Tracking
Feb
15
revised Generating Invoices and Tracking
deleted 7 characters in body
Feb
15
revised Generating Invoices and Tracking
added 130 characters in body
Feb
15
asked Generating Invoices and Tracking
Feb
13
comment Tick boxes and Dropdown
extra_id's (ketchup, Mayo, etc) already mapped into group (see groups and groups_extras) - so therefore use groups_id to apply in items_options_extras or items_options_extras
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?