Delete Table Entries in Smaller Blocks - HSQLDB

Help
APatel-12
2014-08-27
2014-08-27
  • 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