Create a primary key first, before importing, seems to help.

Alike:
CREATE TABLE SRVEV (
ERECNO INTEGER NOT NULL
, ENUM INTEGER NOT NULL
, CODE VARCHAR( 12 )
, ICRECNO INTEGER
, NEWENTRYDATE TIMESTAMP
, PRIMARY KEY ( ERECNO, ENUM )
)

===========================================================

Mike Grover wrote:

>
> Ok, sorry, let me explain.
>
> I get a 150 gig SDF file (fixed record width) file ever three months.
>
> I was previuosly using Codebase 6.5 (xbase file format).
>
> Codebase does not have any SQL support!
>
> Right now I am importing records from a SDF file into a gdb file.
>
> I started 3 hours ago and im at 21 million records of 110 million.
>
> The I will create indexes.
>
> mike...
>
> -----Original Message-----
>
> From: Leyne, Sean [mailto:InterbaseSupport@...]
>
> Sent: Monday, August 13, 2001 3:15 PM
>
> To: 'ib-support@yahoogroups.com'
>
> Subject: RE: [ib-support] Importing Records
>
> Mike,
>
> I'm a little confused... You asked about speeding up an import process,
>
> right?
>
> If so, why would you be querying the external table (with 110 million
>
> rows)?
>
> I would have expected you to import the data from a External file into a
>
> normal database file and then create indexes, triggers, etc. to support
>
> normal table operations.
>
> Did I miss something along the way?
>
> Sean
>
> 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/
>
> 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/