Programming Languages: Java
License: BSD License
+1 How did you solve the problem? What was the cause?.
2013-05-22 05:18:42 PDT by madkroll
No. Leave the indexes as they are.
2013-05-22 02:15:05 PDT by fredt
I am truncating a table and adding new data. - Do indexes need to be dropped and recreated?.
2013-05-21 18:48:25 PDT by dever6
Ok, Thanks for response! Unfortunately I have no chance to use snapshot version. So I decided to avoid of such view creation and use tables directly.
2013-05-21 15:18:15 PDT by madkroll
This works with the latest snapshot jars for 2.3.0.
2013-05-21 15:15:10 PDT by fredt
2013-05-21 14:34:18 PDT by fredt
Failed to create view which based on selection from another already created view. If it is based on selection from existent table - there is no any problem, it works well. Environment: - HSQLDB 2.2.9 - PostgreSQL compatibility mode enabled - java 1.6 Script: CREATE VIEW ab AS ( SELECT 'a' as fst, 'b' as snd ); CREATE VIEW ab_wrapper AS ( SELECT fst, snd FROM ab );...
2013-05-21 13:56:02 PDT by madkroll
Your table does not have any indexes. Therefore any SELECT with LIMIT will load the full set of data into memory to sort and you will run out of memory. Before you insert into the table, add an index on the column you will use for ORDER BY. You can add more than one indexe (on different columns) but the data insert will get slower when there are indexes. Do not add indexes after inserting...
2013-05-20 02:12:59 PDT by fredt
Hi fredt, Thanks for u help problem is solved . But another error coming after inserting the data(15 millions rows and 103 columns and 10.5 GB), then getting the value using sql Query(select * from db_10gb order by col3 limit 10 offset 0). I got a error message as below Exception in thread "Thread-4" java.lang.OutOfMemoryError: Java heap space at...
2013-05-19 22:24:37 PDT by kunalghosh84
What is the size of your .data file after the program terminates with the error? If the size of your .data file reaches 64 GB, then this is the limit. You can increase this limit by uncommenting this line. // execute(con, "SET FILES SCALE 128"); If the size reached is much less than 64GB, the provide the csv. There may actually be an error in your code and rows may be...
2013-05-19 04:20:16 PDT by fredt