Re: [Firebird-net-provider] Filling a table with data

Hello: The call to Update() takes 14 seconds. I'm using the .NET Provider 2.0 Beta 4 and the embedded version of Firebird 1.5.3. Ah think in that the embedded server support is implemented using PInvoke what will have a penalty ... huummm can you do the same test usign the standalone server ??

Re: [Firebird-net-provider] Filling a table with data

Hi Carlos, >The whole code or the Update call only ?? What version of the provider >and the server are you using ?? The call to Update() takes 14 seconds. I'm using the .NET Provider 2.0 Beta 4 and the embedded version of Firebird 1.5.3. Alex Jankowski -

Re: [Firebird-net-provider] Filling a table with data

Hello: I've now been experimenting with to approaches. The first approach I assign a transaction to the insert command as you suggested. 25000 inserts now take 14 seconds. The whole code or the Update call only ?? What version of the provider and the server are you using ?? -- Carlos Guzmán

RE: Re: [Firebird-net-provider] Filling a table with data

Hi Carlos, >Are you using Transactions ?? If yes how ?? You should start a >transaction before doing the Update, and assing that transaction to the >insert command if not if you have 25000 rows there will be 25000 >transactions ( one per command ). I've now been experimenting with to approache

Re: [Firebird-net-provider] Filling a table with data

Hello: I've tryed this, but it performs badly - inserting 25.000 rows takes about 90 seconds, which only takes about 4 seconds using INSERT statements in C++ with the IBPP library. I also tryed using FbCommand to execute 25.000 INSERT statement, but this also performed badly. Are you using Tra

Re: [Firebird-net-provider] Filling a table with data

Hi Carlos, >> What is the best and fastest way to fill data from a DataTable object into a >> table using the .NET provider? >Using, FbDataAdapter.Fill I've tryed this, but it performs badly - inserting 25.000 rows takes about 90 seconds, which only takes about 4 seconds using INSERT statements

Re: [Firebird-net-provider] Filling a table with data

Hello: What is the best and fastest way to fill data from a DataTable object into a table using the .NET provider? Using, FbDataAdapter.Fill -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ --- This SF.Net email is sponso

[Firebird-net-provider] Filling a table with data

Hi, What is the best and fastest way to fill data from a DataTable object into a table using the .NET provider? Thanks in advance. Alex Jankowski --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends a