194 reputation
19
bio website
location
age
visits member for 3 years
seen Nov 13 at 16:43

Oct
3
comment How to store formula method in the table
Yes @grid :) Basically something like Admin click on the formulas setting page on the website and create a formula (Choose Minus, Plus, Fields) and save it. Then go to any category and select a formula from a dropdown to apply. Do you get the idea?
Oct
3
comment How to store formula method in the table
@grid There is no need to use eval() function but something like that yes. Basically on the Admin site, admin select the formula setting on the site.
Oct
3
comment How to store formula method in the table
For example Admin on the websute can select a formula setting on each category and save it. The formula setting could be saved in category_formula table but how the table should be designed.
Oct
3
comment How to store formula method in the table
Thanks for the answer. Is there alternative way to keep a list of formula records in a category_formula table for example? I am not sure what fields do I need but you could answer that. I would use PHP to calculate the sum.
Oct
3
comment How to store formula method in the table
categories will be subject to change however I should be able to apply same formula to many categories if I wanted to. If the formula change - I would create a new formula record and then update on existing categories records.
Sep
17
comment Mobile Phone & Tariffs
Description part into columns is a good idea and I will look into that. My question was is the relationship design between phone, tarrif, network and saleType is ok? I assume you understood from my tables design? Basically operator can select a retailer which then select Mobile Network.. then select what type of sale (eg: consumer upgrade) and then select phone with related related tariffs. Depending what tarrifs and/or phone they have selected - operator gets number of points.
Feb
15
comment Generating Invoices and Tracking
I have managed to translate your SQL Server example into MySQL. I went through and I understood very well now. What would AllocationType would be if I want to send client money? Do I need to insert into CashPayment table as well (let say paying them via BACS)?
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
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
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?!
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
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
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
comment Improve `Update` performance (rows locking issue)
@ypercube it check if the number is valid or invalid from externally (API). If there is an error then return into $error but this is not an issue.
Dec
21
comment Improve `Update` performance (rows locking issue)
@ypercube I have updated my question, how its generated. That is good ideas about grouping but there will be like 10 different type of error texts... and also without error. How can that be archived?