[Mono-bugs] [Bug 49273][Blo] New - Very slow connection via Npgsql from mono 0.26

[bugzilla-daemon@bugzilla.ximian.com]

Please do not reply to this email- if you want to comment on the bug, go to the
URL shown below and enter your comments there.

Changed by yakeen@sannyas-on.net.

http://bugzilla.ximian.com/show_bug.cgi?id=49273

--- shadow/49273	2003-10-03 05:38:05.000000000 -0400
+++ shadow/49273.tmp.24487	2003-10-03 05:38:05.000000000 -0400
@@ -0,0 +1,68 @@
+Bug#: 49273
+Product: Mono/Runtime
+Version: unspecified
+OS: 
+OS Details: Red Hat Linux 9 with Nicquist G2.4 Rpms
+Status: NEW   
+Resolution: 
+Severity: 
+Priority: Blocker
+Component: misc
+AssignedTo: mono-bugs@ximian.com                            
+ReportedBy: yakeen@sannyas-on.net               
+QAContact: mono-bugs@ximian.com
+TargetMilestone: ---
+URL: 
+Cc: 
+Summary: Very slow connection via Npgsql from mono 0.26
+
+Please fill in this template when reporting a bug, unless you know what you
+are doing.
+Description of Problem:
+
+I have to point out that this  started with mono 0.26. 0.25 work fine and
+speed is excellent. I'm trying connect Postgres and get some data.  On my
+Athlon XP 2500+ one SELECT with getting cca 1000 records takes over one
+minute and on mono 0.25 is done in less second with getting data into
+TreeView.  And in 0.26 and higher (actually 0.28) there is no CPU use in
+waiting for data, thats wired...
+
+Steps to reproduce the problem:
+
+1. 
+NpgsqlConnection conn = new NpgsqlConnection(ConnectionString);
+conn.Open();
+querystring = "SELECT log.log_id, log.date, log.time, users.username, "
+			+ "log.message FROM log, users WHERE log.uid=users.uid "
+			+ "ORDER BY log.date, log.time"; //some select - this actualy returns
+cca 1.000 rows
+NpgsqlCommand command = new NpgsqlCommand(querystring, conn);
+NpgsqlDataReader dr = command.ExecuteReader();
+while(dr.Read()){ 
+....
+....
+list.Add (data); //some adding data into ArrayList
+}
+conn.Close();
+
+2. 
+compile 
+
+3. 
+execute
+
+Actual Results:
+
+on 0.26, 0.28 is damned slow
+
+Expected Results:
+
+speed improovements or rollbact into state like in mono 0.25
+
+How often does this happen? 
+
+always
+
+Additional Information:
+
+this block me of using new version of mono....