Re: Performance impact -- multiple databases Vs multiple tables...

2004-11-30 Thread alok gore
Thanks a lot for the quick response :) We are not using MyISAM tables. All our tables are InnoDB tables. The rational behind this decision is that the database is expected to get hundreds of insert queries per second, so we want the row level locking of InnoDB to speed this up. (I should ha

Performance impact -- multiple databases Vs multiple tables...

2004-11-30 Thread Alok Gore
Hi All, I tried digging for this information in the archives but could not find anything. I am in to developing an app. that uses very high amount of data (Close to 80 GB per machine). It has 3-4 logical tables. But I have to partition them in to multiple tables because the mysql table size