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é