wood burning stoves 2.0*
The moose likes JDBC and the fly likes Timing Issues Error/normal HSQLDB/ Java doubt Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Timing Issues Error/normal HSQLDB/ Java doubt " Watch "Timing Issues Error/normal HSQLDB/ Java doubt " New topic
Author

Timing Issues Error/normal HSQLDB/ Java doubt

shubham lahoti
Greenhorn

Joined: Nov 26, 2008
Posts: 3
Hi

Well I am a bit confused if its a hsqldb question or java question but still if some one can answer; here it goes:
Test run approx gave me the time to run second query each time (code: read_2 string - for table2) is some Milli seconds. Isnt it too much time
Full run:
Time approx: 5 days (estimate based on the output for approx 3 days)
Size of table1: 2,355,459 rows, 9 fields, all varchar
Size of table2: 7,392,872 rows 17 fields, all varchar [am using Indexing]
Tables created were cached tables
code:


1 issue definitely is I am calling a query from a query and the second query is on a large table but still main issue is if this time for reading data from 2nd query isn't too much? I have tried with prepared statement too but the performance increment is not that great.
Besides I today tried the same thing thing with mySQL and it was extremely fast (sample: hsqldb- 1 hour; mysql- 17 mins). So can I conclude that HSQLDB isnt that good for large DBs..???

Have gone through this thread http://www.coderanch.com/t/300950/JDBC/java/HSQLDB-users-note
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 38087
    
  22
Please take immediate note of the private message I just sent you
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Timing Issues Error/normal HSQLDB/ Java doubt
 
Similar Threads
loading a csv file
ResultSet Question
java.sql.SQLException: The total number of locks exceeds the lock table size
Transferring final String values in one class to another class in Eclipse.
Metadata repository or DB