RE: [PHP] mysql table speed

> i've got a mysql table with about 150.000 record. > i'm getting data out of this table to generate statistic overviews > > it seems that this is a problem, cause it takes a long time > to generate these overviews > > q: how can i speed up this table cause 150.000 records > is not that much i suppose? You should set up an Index on any fields you commonly search on. The MySQL documentation has information on how to do this. It's at www.mysql.com. I would tell you, but a) It's better to learn it, b) I can't remember, and c) It's 1:30am here and I'm still at work :) Jason -- Jason Murray jasonm@melbourneit.com.au Web Developer, Melbourne IT "What'll Scorpy use wormhole technology for?" 'Faster pizza delivery.'