Re: InnoDB or MyIsam?

2002-07-05 Thread mos
At 06:28 AM 7/5/2002, you wrote: >Hello! :) > >I'm wondering which table type is better and why for >web project with about 100 000 customers. May be >InnoDB gives better query performance? I'm using now >MyIsam, but is this better idea to move to InnoDB? > >Thank you! :) In addition to Steve's c

RE: InnoDB or MyIsam?

2002-07-05 Thread Steve Bradwell
It all depends if you need to use transactions. If you are entering items from a cart into a database you may want to use transactions to make sure ALL items get written correctly before you actually commit the changes to the database. With InnoDB tables you can use transactions so if one or all i