Delete Table Entries in Smaller Blocks - HSQLDB

  • APatel-12

    APatel-12 - 2014-08-27

    'Delete from table' query causes out of memory exception in my java program. Deleting large tables into smaller blocks may be a solution.

    My question is, what should be the query to delete table in smaller blocks. I have tried both of the following queries, but none of them worked with hsqldb 1.8.

    (1) delete from t where key IN (select key from t limit 100)
    (2) delete from t where rownum() < 100

    Looking forward for your suggestions.

  • Fred Toussi

    Fred Toussi - 2014-08-27

    The first one should work with some old versions. The second one is better and works in the new version.

    Last edit: Fred Toussi 2014-08-27

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

No, thanks