Hello:
Looks like you are runnint the inserts using always implicit
trasnactions what will cause 25000 transactiosn to be created and
committed, try using explicit transactions.
----Mensaje original----
De: [EMAIL PROTECTED]
Recibido: 25/10/2005 10:29
Para:
<Firebird-net-provider@lists.sourceforge.net>
Asunto: [Firebird-net-
provider] High load causing server quit?
Hi all.
I'm using 1.7a (is
this the most recent stable build?
the web page says 1.6.3 is but
doesn't provide links
to download it...) for some simple tests.
I have
a loop inserting items into a test DB by
building a string, creating a
NpgsqlCommand and
calling ExecuteNonQuery. The same connection is used
for all the inserts.
However, if I insert more than 25,000 rows an
exception is thrown and the Firebird server process
exits!
Am I doing
something wrong?
Exception details:
Started up at 25/10/2005 08:48:
48 ,
Initialising connection...
using ADO
on Firebird 00:
00:02.0625000
Deleting... , 00:00:02.4062500
Populating 100
categories... , 00:00:01.2656250
Populating 25000 products... ,
Unhandled Exception:
FirebirdSql.Data.Firebird.FbException: Error
reading
data from the connection.
at FirebirdSql.Data.Firebird.
FbTransaction.Commit()
at
FirebirdSql.Data.Firebird.FbCommand.
CommitImplicitTransaction()
at
FirebirdSql.Data.Firebird.FbCommand.
ExecuteNonQuery()
at OPathExperiments.AdoTests.PopulateProducts
(Int32
number, Int32 maxPrice)
at OPathExperiments.Program.RunTests
(IDBTests
tests, DBType dBType, String connectionString)
at
OPathExperiments.Program.Main(String[] args)
Cheers.
___________________________________________________________
Yahoo!
Messenger - NEW crystal clear PC to PC calling worldwide with voicemail
http://uk.messenger.yahoo.com
-------------------------------------------------------
This SF.Net
email is sponsored by the JBoss Inc.
Get Certified Today * Register for
a JBoss Training Course
Free Certification Exam for All Training
Attendees Through End of 2005
Visit http://www.jboss.
com/services/certification for more information
_______________________________________________
Firebird-net-provider
mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.
sourceforge.net/lists/listinfo/firebird-net-provider
-------------------------------------------------------
This SF.Net email is sponsored by the JBoss Inc.
Get Certified Today * Register for a JBoss Training Course
Free Certification Exam for All Training Attendees Through End of 2005
Visit http://www.jboss.com/services/certification for more information
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
