Subject Re: [firebird-support] main differences FB / MySQL
Author Martijn Tonies
> > MySQL stored each table and index in its own file....
> >
> > Firebird stores its whole database in a single logical file ...

Partly true :-)

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