MySQL Select Optimisation
#3

Quote:
Originally Posted by AndreT
Посмотреть сообщение
Why on earth do you need 180 gramX fields, anyways? What does each zero stand for?
Knew you would ask this!

Anyway - I need it for each drug gram on the server so it can be logged.

The first zero stands for - Drug Gram Availibility: Whether it is allowed to be used slot or if it is taken.

The second zero stands for - Drug Gram Type - 0 means set it to 1 in the script. 1 means Stale drugs and 2 means freshly grown.

The third zero holds a time of upto 9999 and it counts down in the script. When it reaches 0 it means convert the drug type from 2 to 1.
Reply


Messages In This Thread
MySQL Select Optimisation - by Kyle - 21.12.2012, 14:52
Re: MySQL Select Optimisation - by AndreT - 21.12.2012, 14:54
Re: MySQL Select Optimisation - by Kyle - 21.12.2012, 14:59
Re: MySQL Select Optimisation - by AndreT - 21.12.2012, 15:08

Forum Jump:


Users browsing this thread: 2 Guest(s)