On Jun 13, 2008, at 1:06, Arun Singhal wrote:
I have million of reords in a table and I want to update a column
in the
same table by checking value of another column in the same table.
For e.g.
two columns A and B. Now if the value of column A is X then update
value of
column B as true else false. Now to apply this functionality on
that table
in mysql is taking huge time.
How are you attempting to do it now? I can't imagine you being able
to do that faster than with a simple SQL query.
I want to reduce the time by using memcache.
Can you guide me how can I do that using memcache?
This is sort of like declaring your car to be too slow and asking
someone to install a larger exhaust pipe on it because fast cars have
large exhaust pipes. You may find that the larger exhaust pipe
doesn't do nearly as much to speed up your car as shifting into
second gear does.
So to truly help you, we must first understand your problem. My
suspicion is that you just have a bad query or too few or (or
possibly too many) indices. If I believed memcached would solve your
problem, I *still* wouldn't be able to tell you how it to apply it
without knowing exactly what you're doing.
