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 -~----------~----~----~----~------~----~------~--~---
