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

David Makovský (Yakeen) yakeen at sannyas-on.net
Mon Oct 20 05:04:17 EDT 2003

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

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:

NpgsqlConnection conn = new NpgsqlConnection(ConnectionString);
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();
list.Add (data); //some adding data into ArrayList



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

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 

More information about the Mono-devel-list mailing list