Hi, Could you send a complete SQL script or a simple Java test case (one class, a main method, no dependencies) that creates the database and inserts the data?
I can't see anything wrong with your code, but then I don't see exactly what are the other SQL statements, the JDBC URL and so on. Regards, Thomas On Mon, Oct 13, 2008 at 10:21 PM, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Also, the code I have posted should be > conn.prepareStatement(createIndexingQueryString); not > conn.prepareStatement(createTableQueryingString); > > On Oct 10, 11:05 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> > wrote: >> have also tried oneindexon multiple attributes. >> >> On Oct 10, 5:37 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: >> >> > 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 myindexfile >> > 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 myindexfileoutput 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 >> >> > <indexfile> >> > -- H2 0.5/B -- >> > -- H2 0.5/B -- >> > -- H2 0.5/B -- >> >> > //a line of ascii squares here >> > </indexfile> >> >> > <code> >> >> > String createIndexingQueryString = "CREATEINDEXIDX_A on >> > THE_TABLE (a);"; >> > conn.prepareStatement(createTableQueryString); >> > ps.execute(); >> >> > createIndexingQueryString = "CREATEINDEXIDX_B on >> > THE_TABLE (b);"; >> > conn.prepareStatement(createTableQueryString); >> > ps.execute(); >> >> > createIndexingQueryString = "CREATEINDEXIDX_C on >> > THE_TABLE (c);"; >> > conn.prepareStatement(createTableQueryString); >> > ps.execute(); >> >> > createIndexingQueryString = "CREATEINDEXIDX_D on >> > THE_TABLE (d);"; >> > conn.prepareStatement(createTableQueryString); >> > ps.execute(); >> >> > createIndexingQueryString = "CREATEINDEXIDX_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 -~----------~----~----~----~------~----~------~--~---
