Subject | Re: Handling large imports while system is in production |
---|---|
Author | un_spoken |
Post date | 2013-02-05T17:57:59Z |
--- In firebird-support@yahoogroups.com, "rudibrazil78" wrote:
I would like to hear your strategies for this sort of problem:)
>We have the same problem. We are importing daily like 1000000 rows. There are 100000 new rows each day and the rest are the rows which are updating the ones which are already in the database. Import takes about an hour for 100k rows. During the import many things can go wrong..
> Hi all
>
> We've been having to deal with a bad situation for quite a few years now - how to handle large imports without taking the server down (in fact that data is meant to be acessible as soon as its ready in production).
I would like to hear your strategies for this sort of problem:)