Re: SELECT from several tables - Tim Groove - com.mysql.lists.mysql

8 messages in com.mysql.lists.mysqlRe: SELECT from several tables

From	Sent On	Attachments
Martin Ramsch	11 Sep 1999 12:38
Martin Ramsch	11 Sep 1999 14:02
Paul DuBois	11 Sep 1999 14:10
Benjamin David Hildred	11 Sep 1999 17:09	.php3
d e l d h a n o a	11 Sep 1999 17:48
Tim Groove	11 Sep 1999 20:29
Tim Groove	11 Sep 1999 23:37
Alexander I. Barkov	12 Sep 1999 07:19

Subject:	Re: SELECT from several tables
From:	Tim Groove (cheg...@hotmail.com)
Date:	09/11/1999 11:37:53 PM
List:	com.mysql.lists.mysql

On Sat, 1999-09-11, Martin Ramsch wrote:

If not, what is the best way? Maybe temporary copying into one big table?

Actually, I think the best way is to change your table design!

For example, why not just use a single table, and then SELECT COUNT(*) FROM tab WHERE uid=###;

I can't because this table is very big (it's size is about 200MB every evening) Each new INSERT lasts for second or two when table become big enough (it has indexes and several "char" fields also) and other processes are locked and awaiting while INSERT will be done. I need about 400 new INSERTs each minute, so I decided to split one big table to 24 parts to speed up INSERT process. Or this is wrong way?