Subject | RE: [firebird-support] Maintenance of temporary tables |
---|---|
Author | Alan McDonald |
Post date | 2004-06-22T13:39:15Z |
> I'm using a fake temporary table to hold lists of IDs. It has two fields :Is there only one person sing this temp table? or one per user?
> LISTID and ID.
> The common scenario is that I insert records in this table at the
> start of a
> tansaction and delete them all when committing, so that the table always
> "looks" empty.
>
How long does this transaction stay open?
> I expect to insert and delete at most 300000 rows a day (10oooooh, sweep every night eh? suck it in every night - blow it out every
> consecutive days
> per month).
>
> What kind of issues should I expect and how should I prevent them ?
>
> Some ideas ...
>
> Should I issue a "Select count(*)" every once in a while during the day to
> take care of GC, or should I leave that up the nightly SWEEP ?
day... seems like a waste of time to me. Let your databse server manage it's
own space requirements, i'll use what it's created very efficiently.
Alan