Hi grass-users,
Recently, I read the following (g.manual v.to.db):
"If the module is apparently slow and the map attributes are stored in an
external DBMS such as PostgreSQL, it is highly recommended to create an
index on the key (category) column."
How is this done?
Best regards,
Wolfgang
--
Lust, ein paar Euro nebenbei zu verdienen? Ohne Kosten, ohne Risiko!
Satte Provisionen für GMX Partner: http://www.gmx.net/de/go/partner
Hello Wolfgang,
On Thu, 26 Jan 2006 10:59:11 +0100 (MET) "Wolfgang Qual"
<Wolfgang.Qual@gmx.net> wrote:
Hi grass-users,
Recently, I read the following (g.manual v.to.db):
"If the module is apparently slow and the map attributes are stored
in an external DBMS such as PostgreSQL, it is highly recommended to
create an index on the key (category) column."
How is this done?
Refering to Postgres you could have a look here[1]. At the bottom of
the page an example is explaned.
Since you are probably working with SQLITE3, you should have a look in
thier docs[2] for actual syntax.
HTH
Stephan
[1] http://www.postgresql.org/docs/current/static/sql-createindex.html
[2] http://www.sqlite.org/lang_createindex.html
--
GDF Hannover - Solutions for spatial data analysis and remote sensing
Hannover Office - Mengendamm 16d - D-30177 Hannover
Internet: www.gdf-hannover.de - Email: holl@gdf-hannover.de
Phone : ++49-(0)511.39088507 - Fax: ++49-(0)511.39088508
On 1/26/06, Wolfgang Qual <Wolfgang.Qual@gmx.net> wrote:
Hi grass-users,
Recently, I read the following (g.manual v.to.db):
"If the module is apparently slow and the map attributes are stored in an
external DBMS such as PostgreSQL, it is highly recommended to create an
index on the key (category) column."
How is this done?
Index is created automaticaly by most of GRASS modules.
You only need to create index manualy for tables connected by
v.db.connect.
Radim
Best regards,
Wolfgang--
Lust, ein paar Euro nebenbei zu verdienen? Ohne Kosten, ohne Risiko!
Satte Provisionen für GMX Partner: http://www.gmx.net/de/go/partner