How big is this million record insert script? Counting the bytes it should
be approx 60Mb script no?
That's pretty big for any program to load and run. The question would be
load time into the script software - not the insert time into the database.
Alan
-----Original Message-----
From: Fredrik Larsson [mailto:fredrik.larsson@...]
Sent: Thursday, 31 October 2002 1:01
To: ib-support@yahoogroups.com
Subject: SV: [ib-support] Simple challenge


How about making your own simple application that reads the line one by
one
and executing them?
I think IB Console updates other Windows when you are executing the SQL so
I
am not sure that it is the ultimate way. If you do your own app you can
get
progress and see what is really happening. You should probably turn off
sweeping (standard at every 20 000 record I think. You should convert
20020101 to 2002-01-01 so that it handle the date automatically. Maby an
index on OneID as well.

Good luck!

> -----Ursprungligt meddelande-----
> Från: clementdoss [mailto:cdoss@...]
> Skickat: den 30 oktober 2002 13:01
> Till: ib-support@yahoogroups.com
> Ämne: [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
>
>
>
> 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/

>

Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]