Subject | I need to use temp tables |
---|---|
Author | Salva |
Post date | 2002-01-28T08:18:29Z |
Hello,
I'm trying to convert a very big application from DB7 to interbase. I use
temporal tables for several process, one for every user doing the same work
(local work). The only way I have found to do this is to create new tables
on the .gdb (database) and drop them when finished.
(In DB7 I created new table files on local dir on user's machine)
I have some quiestions about this:
- Creating new table is the correct way of doing it?
- The fact of creating-dromping tables will de-optimize the database too
much?
Thanks, Salva
I'm trying to convert a very big application from DB7 to interbase. I use
temporal tables for several process, one for every user doing the same work
(local work). The only way I have found to do this is to create new tables
on the .gdb (database) and drop them when finished.
(In DB7 I created new table files on local dir on user's machine)
I have some quiestions about this:
- Creating new table is the correct way of doing it?
- The fact of creating-dromping tables will de-optimize the database too
much?
Thanks, Salva