I guess that if you commit after every xxx inserted records, the result
could be better ..
Ales

> -----Original Message-----
> From: clementdoss [mailto:cdoss@...]
> Sent: Wednesday, October 30, 2002 1:01 PM
> To: ib-support@yahoogroups.com
> Subject: [ib-support] Simple challenge
>
>
> Hi all,
>
> My customer has challenged me and other 3rd part developers to prepare
> some tests for different DBMS.
> They have given us a sort of 'pseudo query SQL statement' that we must
> implement and run against the databases we are choosing...
>
> This one is very simple... insert 1 milion records.
>
> Here is the table
>
> create table TB_LargeTable (
> OneID INTEGER,
> OneStatus char(1),
> OneDate TimeStamp
> );
>
>
> they sent us a script with a milion rows of:
>
> insert into TB_LargeTable values ( 1 , 'A' , '20020101' );
> insert into TB_LargeTable values ( 2 , 'C' , '20020101' );
> insert into TB_LargeTable values ( 3 , 'A' , '20020102' );
> .... until a milion
> insert into TB_LargeTable values ( 1000000 , 'T' , '20020821' );
>
> What would be the best way to run this script?
> Will FB understand this date format YYYYMMDD?
> ( Of course I have tried to run the script. After 2 hours nothing has
> been done, I figured out that I was missing something.)
> Is there a native tool (ie. isql) that could handle file this large?
> How can I use it?
>
> Please don´t get me wrong , but others has ran this same script for
> different RDMS and they run just fine in under an our. I guess I must
> use the right tool to run this script.
> All the systems are the same. Win2k Pro 512 MB, 60 Gbytes.
> All the RDBMS are installed locally, so we are running the script on
> the same machine where the SQL Server is.
>
>
> Best regards,
> Clément
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-->
> Get 128 Bit SSL Encryption!
> http://us.click.yahoo.com/JjlUgA/vN2EAA/kG8FAA/67folB/TM
> --------------------------------------------------------------
> -------~->
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>