Hi, 5 million rows isn't all that huge, the following script will create a table with that many records in about 40 seconds. The database size is about 100 MB (after "shutdown defrag"):
drop table if exists test; create table test( id int primary key, name varchar(255), created timestamp) as select x, 'hello world ' || x, now() from system_range(1, 5000000); Regards, Thomas On Thu, Oct 29, 2015 at 9:28 AM, Benjamin Asbach <[email protected] <javascript:_e(%7B%7D,'cvml','[email protected]');>> wrote: > My initial thought was rows. I know it makes a difference if you have 10 > or 100 columns. I just want to get a feeling how and if others handle huge > amount of data. > > Thanks > Benjamin > > > Am Mittwoch, 28. Oktober 2015 12:11:54 UTC+1 schrieb Steve McLeod: >> >> 5M+ whats? rows? bytes? >> >> >> On Tuesday, 27 October 2015 10:10:04 UTC+1, Benjamin Asbach wrote: >>> >>> Hi there, >>> >>> I'm looking for some experiences which tables with a huge amount of data >>> (5M+). To be a little bit more concrete what I'm interested in: >>> >>> * How much data do you store (lines per table (amount of columns) , >>> total lines) >>> * Which hardware you use (CPU, RAM) >>> * How you run H2 >>> * How do you query your database and how's the response time >>> >>> Looking forward for feedback >>> Benjamin >>> >> -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] > <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> > . > To post to this group, send email to [email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
