Re: [gnome-db] gda_connection_update_meta_store() is slow

["Vivien Malerba" <vmalerba gmail com>]

2008/12/16 Murray Cumming <murrayc murrayc com>

In libgda-3.0 we used gda_connection_get_schema() as needed in Glom to
discover:
- The list of field types supported by the server.
- The list of tables.
- The list of fields for each table.

But in libgda-4.0 we must use gda_connection_update_meta_store() and
then look at the meta store to get that information. But that doesn't
allow us to just discover the field types or tables, without updating
all the other information too. And it's very slow, taking around 15
seconds on my PC with a local Postgres server. 

Is there a better way to do this?

You can request only a artial update of the meta store for the tables in which you are interrested: _tables, _columns, _builtin_data_types (and also _domains, _udt and _element_types if you also want those kind of data types).

Attached is a sample code to do this.

Vivien
 

Attachment: test.c
Description: Binary data