| Subject | Re: Help | 
|---|---|
| Author | lysander_fb | 
| Post date | 2005-06-02T17:29:13Z | 
--- In firebird-support@yahoogroups.com, RONALD STARK <starkr@t...> wrote:
And HOW are you migrating?
I also have a huge conversion task while the application is in use
every day, so I often need to batch-insert data. If you are using
dBase-Language or Delphi, you can easily control the transaction and
hard-commit-intervals.
Make sure you understand about the difference in using indexes in
Firebird and dBase/FoxPro. dBase needs a lot more indexes than
Firebird does. Batch-inserts can get very slow when indexes are involved.
ciao,
André
            > Hi,Which language are you using for migration?
> I'm migrating data from DBFs to firebird tables.
And HOW are you migrating?
I also have a huge conversion task while the application is in use
every day, so I often need to batch-insert data. If you are using
dBase-Language or Delphi, you can easily control the transaction and
hard-commit-intervals.
Make sure you understand about the difference in using indexes in
Firebird and dBase/FoxPro. dBase needs a lot more indexes than
Firebird does. Batch-inserts can get very slow when indexes are involved.
ciao,
André