Hi, I can't say what the problem could be. We would need a simple, complete, reproducible test case.
Regards, Thomas On Tuesday, May 6, 2014, Daniel Hopins <[email protected]<javascript:_e(%7B%7D,'cvml','[email protected]');>> wrote: > Hi folks first post here..bare with me.. > > I have noticed when we do a delete from blah where date < xxx'' limit y > > A temp table is always being generated..regardless if the limit is say 100 > or 10000. > > Is there anyways around this? (given this delete statement will never be > rolled back?..can rollback be disabled?) > > I have found doing a limit 20, appears to execute 'fast' (0.008seconds), > but when we do limit 100 it takes about 3 seconds..which of course blocks > all other access to the table in question..which (for our use case is not > acceptable). > > ps. the date column does have an index.. > > thanks > Dan > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
