Subject | Re: [firebird-support] main differences FB / MySQL |
---|---|
Author | Martijn Tonies |
Post date | 2005-07-30T07:19:08Z |
> > MySQL stored each table and index in its own file....Partly true :-)
> >
> > Firebird stores its whole database in a single logical file ...
The InnoDB storage system, by default, stores everything
into a special InnoDB tablespace. This tablespace, by default,
is used for all databases (or actually, all InnoDB tables).
There's a setting that says "innodb_file_per_table" to get
"around" this.
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com