Subject | Re: Natural Join |
---|---|
Author | Adam |
Post date | 2005-06-07T21:09:09Z |
> Are cross database joinsNo, each query can only access a single database, however a
transaction can span several databases, and two phase commits work so
it really depends on your needs.
> > > Bulk insertIn addition to Set's comments, it does certainly support most things
> > > Bulk update
> > > Bulk fetch
needed to do Bulk inserts / updates but you may have to temporarily
disable the triggers and indices on the appropriate tables if
performance is a problem. FB supports prepared queries and stored
procedures which allows you to prepare the query once so you don't
have to wait for the optimiser each time.
Adam