Hi,

> I want to create new database, there is option to create multi file
> database, what should I choose? Is multi file database is better than
> single? And what's the pros and cons of each option?

Multi-file databases were needed before there was 64bit I/O
routine for huge files (larger than 4Gb). These days, there's no
real need, unless your harddisk is too full so you can put additional
datafile on another drive.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com