On Mon, 2006-10-09 at 13:02 +0700, Ady Wicaksono wrote:
> On 10/9/06, Ow Mun Heng <Ow.Mun.Heng@stripped> wrote:
> > On Mon, 2006-10-09 at 11:42 +0700, Ady Wicaksono wrote:
> > > Is your MSSQL data structure contain such foreign key?
> > >
> > > If yes, my isam is not suitable for you
> > Actually, you know what? I don't really know.
> > How does one go about checking?
> Dump it to SQL, and make sure you know how foreign key SQL syntax
Thanks. I'll take look.
> > > Others... for overall, i prefer innodb :)
> > I know it's transaction safe and all, but not too sure if I need the
> > extra overhead.
> If your concern is fast insert, how fast do you need? is 3000 rows
> insert/seconds enough?
I think That's _way_ enough. Looking through the select (group by
date/time etc) I see the max is ~2000 or so inserts (per Minute :-))
> if your concern is fast read, tune your innodb buffer, bigger memory
> bigger performance :)
My concern is fast reads. Based on
the innodb_buffer_pool_size should be ~70-80% of main memory.