Re: [gnome-db] postgresql provider performance



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]