I think my first question would be… why are there 100 columns in your mysql table? I get the feeling some better database design would improve this more than grabbing ridiculous numbers of columns. (remember you’ve also gotta store all that data in PHP - which has a fixed memory size)