On the weekend, I tried doing a local filesystem connect to a database,
instead of via tcp/ip

Via TCP/IP
$conn = ibase_connect("localhost:/u1/db/data.fdb","sysdba","masterkey");
Via Local (Process run as root)
$conn = ibase_connect("/u1/db/data.fdb","sysdba","masterkey");

The performance jump was incredible. It was easily 10x faster. As expected,
the Firebird engine was pulled into the running application, rather than
launching an 'fb_inet_server' process.

Apart from the one drawback(I can see) of the process locking the database
file, therefore locking all others (including 'fb_inet_server') out of the
file (well, at least, it can't do anything until the first process is
finished), are there any other traps, gotchas, or things to watch out for?

Sorry this is a weirdly crafted question.

N.

Nigel Weeks
Tech Support & Systems Developer
nweeks@...
www.examiner.com.au
71 - 75 Paterson Street
Launceston
Tasmania 7250
Australia
Phone: 03 6336 7234



[Non-text portions of this message have been removed]