Hi all,
I'm evaluating and prototyping. I'm also using JDBC.
Off topic question: can I pre-grow my database size?
Now to the real question:
I have indexed over a few columns as shown below, but my index file
doesn't grow when I write 1M rows to the database. Also, there is no
error or exception. Furthermore, the benchmarks with indexing and
without are about the same!
I have included my index file output after these 1M writes.
I don't see how I'm doing anything wrong, but I probably am anyway.
Can anyone shed some light on the situation?
Thanks in advance,
Julian
<index file>
-- H2 0.5/B --
-- H2 0.5/B --
-- H2 0.5/B --
//a line of ascii squares here
</index file>
<code>
String createIndexingQueryString = "CREATE INDEX IDX_A on
THE_TABLE (a);";
conn.prepareStatement(createTableQueryString);
ps.execute();
createIndexingQueryString = "CREATE INDEX IDX_B on
THE_TABLE (b);";
conn.prepareStatement(createTableQueryString);
ps.execute();
createIndexingQueryString = "CREATE INDEX IDX_C on
THE_TABLE (c);";
conn.prepareStatement(createTableQueryString);
ps.execute();
createIndexingQueryString = "CREATE INDEX IDX_D on
THE_TABLE (d);";
conn.prepareStatement(createTableQueryString);
ps.execute();
createIndexingQueryString = "CREATE INDEX IDX_E on
THE_TABLE (e);";
conn.prepareStatement(createTableQueryString);
ps.execute();
</code>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en
-~----------~----~----~----~------~----~------~--~---
