Re: [gnome-db] postgresql provider performance
- From: Diego Zuccato <diego otello alma unibo it>
- To: gnome-db-list <gnome-db-list gnome org>
- Subject: Re: [gnome-db] postgresql provider performance
- Date: Fri, 01 Feb 2008 08:40:10 +0100
Vivien Malerba ha scritto:
It seems the "SELECT 1..." query is sent whenever
gda_data_model_describe_column() is called, and it can be optimized to
be called only once...
Wasn't "something" to analyze the db structure available?
It's a lot I don't use gda (I usually access pg directly), but IIRC
there were "dictionaries" (XML files) that, once created, cached a lot
of data... Shouldn't constraints/keys/etc be there, too? So that, in the
worst case, the startup is slightly delayed (to analyze the db), but
then there's nearly no slowdown...
BYtE,
Diego.
[Date Prev][
Date Next] [Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]