[sqlite] Multi-User design

[Chris Ulliott]

Hi All,
 
When using SQLite3 in a multi user environment is it better to have a
single table per database file or is it better to have just one file
which contains all tables in the database?
 
I am worried about the file locking, I do not want users to have to wait
for a table to become accessible just because another user is updating a
different table within the database.
 
What is the cost of performance if I put the tables into separate
database files?
 
Kind Regards,
 
Chris