• 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Timing Issues Error/normal HSQLDB/ Java doubt

 
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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: 79153
377
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Please take immediate note of the private message I just sent you
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic