[Mono-devel-list] Very slow connection via Npgsql from mono 0.26, 0.28

[David Makovský (Yakeen)]

Hi,
I already filled this as a bug nr. 49273
Gonzalo Paniagua Javier wrote me that would be good to sent it here
too...

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


Please for sure read your answears cc me I not in the list
Thanks

-- 
David Makovský (Yakeen) <yakeen at sannyas-on.net>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ximian.com/pipermail/mono-devel-list/attachments/20031020/706a3213/attachment.html