Win a copy of 97 Things Every Java Programmer Should Know this week in the Java in General forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Jeanne Boyarsky
  • Junilu Lacar
  • Henry Wong
Sheriffs:
  • Ron McLeod
  • Devaka Cooray
  • Tim Cooke
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Frits Walraven
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • salvin francis
  • fred rosenberger

Timing Issues Error/normal HSQLDB/ Java doubt

 
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 https://coderanch.com/t/300950/JDBC/java/HSQLDB-users-note
 
Marshal
Posts: 69447
277
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please take immediate note of the private message I just sent you
 
Something must be done about this. Let's start by reading this tiny ad:
Devious Experiments for a Truly Passive Greenhouse!
https://www.kickstarter.com/projects/paulwheaton/greenhouse-1
    Bookmark Topic Watch Topic
  • New Topic