You are thinking like an ISAM programmer.

Embedded is superserver in a DLL. Use superserver instead if you need
accessibility from multiple app instances, whether on one physical box
or several.

In the RDBMS world, only the server (firebird) has direct control of the
hardware. It worries about concurrency so you don't have to (so much).

So long as you are not using the embedded server, and you follow a few
simple patterns, you can support a large number of concurrent users. I
believe 1024 is Firebird's max, but Ann or Helen can correct me.

There is no need to worry about "read-only" so long as your app is
halfway intelligent.

The logical unit of work to an RDBMS is the transaction. During a
transaction, your application will issue a set of select, insert,
update, and delete requests to the database server. The server will
perform the work, but will not allow it to be seen by other
transactions, until you send the commit signal. On commit, all of your
work will be applied and will become visible.

Don't uses BDE like constructs with a relational system. The BDE is
built around ISAM, where your application has physical control of the IO
system. BDE constructs, and other programming techniques built around
ISAM, fail miserably when you try to use them against a relational
system.

The general pattern for scalable applications is to select your data for
display in one transaction, alter the data without posting it to the
database, then post all of the changes together when the user presses
the "save" button.

If you really need to use data aware controls, use a TClientDataset in
briefcase mode to hold the data in memory during your GUI and
application processing.

I hope this helps.

On Sat, 2006-03-11 at 20:32 +0000, gene_lamb wrote:
> With Firebird embedded can I safely access the same DB from multiple
> sources if all sources but one are read only?
>
>
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
>
>
> SPONSORED LINKS
> Technical support
> Computer technical
> support
> Compaq computer
> technical support
> Compaq technical
> support
> Hewlett packard
> technical support
> Microsoft technical
> support
>
>
> ______________________________________________________________________
> YAHOO! GROUPS LINKS
>
> 1. Visit your group "firebird-support" on the web.
>
> 2. To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
> 3. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service.
>
>
> ______________________________________________________________________
>