> ahhh... now we are getting somewhere.
>
> Here is a suggestion... start a new thread, with a clear and relevant
> subject line, describe your app succinctly, note that it works on such
> and such machine, and that it fails to work on such and such machine,
> describe exactly what "does not run"
On 11/19/08, Christophe Leske <[EMAIL PROTECTED]> wrote:
>
>
> > Why don't you just do a
> >
> > DELETE FROM table;
> >
> > and start inserting new results? (end result is the same as dropping
> > and then recreating the table, but you wouldn't know).
> >
> >
> I am worried about creeping memory
> Any chance that you could hint at the subject matter of the questions
> in the Subject line ? In this case it would appear to be Performance ...
> Helps to get your questions answered !
> ;-)
>
Yes, will do so. My apologies.
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
> Why don't you just do a
>
> DELETE FROM table;
>
> and start inserting new results? (end result is the same as dropping
> and then recreating the table, but you wouldn't know).
>
I am worried about creeping memory useage, as this is in-memory.
The timing in the app is critical, not on my dev
Christophe Leske <[EMAIL PROTECTED]> writes:
>
>
>
Any chance that you could hint at the subject matter of the questions
in the Subject line ? In this case it would appear to be Performance ...
Helps to get your questions answered !
;-)
Regards,
MikeW
On 11/19/08, Christophe Leske <[EMAIL PROTECTED]> wrote:
>
> > I don't know. Have you run an experiment to see for yourself?
> >
>
> Yes, but my results are inconclusive.
would you like to share your results? If you timed two tasks,
comparing their timing would be inconclusive *only* if there
> I don't know. Have you run an experiment to see for yourself?
>
Yes, but my results are inconclusive.
Currently, i am doing this:
drop table idlookup;create temp table idlookup as select id from (select
statement for temporary result set)
Thus the statement is shorter than
create temp
On Nov 19, 2008, at 7:08 AM, Christophe Leske wrote:
> Hi,
>
> some more questions...
>
> I am using in-memory temporary tables with results sets created on
> the fly.
>
> On each round, i would like to create a new table with those interims
> results. Question is:
>
> - what is
Hi,
some more questions...
I am using in-memory temporary tables with results sets created on the fly.
On each round, i would like to create a new table with those interims
results. Question is:
- what is quicker/better? Dropping the temporary table on every time and
recreate it from
9 matches
Mail list logo