Subject | Bulk loader. |
---|---|
Author | Claudio Valderrama C. |
Post date | 2007-11-03T09:21:19Z |
Hello, I see the request for a bulk loader appearing from time to time in
our lists.
I understand a bulk loader is a facility able to do a batch insertion with
fast data insertion rates.
But our normal, single row insertions are -generally speaking- acceptable in
speed and faster than other servers.
Therefore, to put the horse before the cart:
- Why do users need a bulk loader? Aren't we enough fast to insert records?
For example, our classic solution is to prepare a parameterized INSERT
statement and keep feeding data as parameters.
- What features do users expect from a bulk loader? It's mostly a client
side thing or a set of improvements in the server side, too?
- Perhaps this email should be sent to firebird-support instead?
C.
---
Claudio Valderrama C.
SW developer, consultant.
http://www.cvalde.net - http://www.firebirdsql.org
our lists.
I understand a bulk loader is a facility able to do a batch insertion with
fast data insertion rates.
But our normal, single row insertions are -generally speaking- acceptable in
speed and faster than other servers.
Therefore, to put the horse before the cart:
- Why do users need a bulk loader? Aren't we enough fast to insert records?
For example, our classic solution is to prepare a parameterized INSERT
statement and keep feeding data as parameters.
- What features do users expect from a bulk loader? It's mostly a client
side thing or a set of improvements in the server side, too?
- Perhaps this email should be sent to firebird-support instead?
C.
---
Claudio Valderrama C.
SW developer, consultant.
http://www.cvalde.net - http://www.firebirdsql.org