> 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
[EMAIL PROTECTED]
Web Developer, Melbourne IT
"What'll Scorpy use wormhole technology for?"
'Faster pizza delivery.'
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
