in reply to Re: read a huge mysql Table into memory
in thread read a huge mysql Table into memory

sorry was not precise: 10/s pagehits each containing several (different pages with different tasks but a good average would be around 15 ) mysql tasks so we talk more in the range of 150 to 200... and then see my reply above, speed is what counts :)
  • Comment on Re^2: read a huge mysql Table into memory

Replies are listed 'Best First'.
Re^3: read a huge mysql Table into memory
by CountZero (Bishop) on May 31, 2009 at 06:32 UTC
    That should still be within the possibilities of MySQL.

    CountZero

    A program should be light and agile, its subroutines connected like a string of pearls. The spirit and intent of the program should be retained throughout. There should be neither too little or too much, neither needless loops nor useless variables, neither lack of structure nor overwhelming rigidity." - The Tao of Programming, 4.1 - Geoffrey James