On Tuesday, 16 April 2013 20:28:39 UTC+5:30, sukumar madawat wrote:
>
> Hi I have created a table using 
> CREATE  TABLE Test column1 VARCHAR PRIMARY KEY, Column2 VARCHAR , column3 
> BIGINT ,column4 BIGINT , column5 VARCHAR(512))
>
> I need to insert 5Million rows to this table and some of the rows I need 
> to update.
> what dbsetting i should use?
>
> Also truncating table and dropping the table taking long time. 
> How should I speed it up?
>
> Thanks & Regards
> Sukumar
>
>
I am using h2 in embedded mode

-- 
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?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.


Reply via email to