--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:

> >
> > I'm all ears for a better way. I started out with permanent
> > temporary tables but couldn't figure out the multi user issues.
> > Apparently, a session ID would resolve this. Where can I learn

more

> > about this technique? What happens when more than one user

needs to

> > run the same operation?
> >
> > Steve
>
> It could be that you don't even need sessionids - what are you

doing

> exactly?
> Alan

Mostly reports but other operations also. I'm rolling up data from
several tables and performing calculations on it for reports or
display. I was rolling it all up into DBISAM in memory tables but
this was too slow. I'm now using a series of stored procedures to
roll it all up into temp tables. This is blazing fast but now that
the temp tables are part of the database (instead of part of the
local user's stuff), I'm concerned about multiple users running the
same operation. I think the session ID sounds very feasible and
easy to implement. Is there a better way?

Steve