Re: [Qgis-developer] oracle performances

2013-02-26 Thread Giovanni Manghi
Hi Jurgen On Mon, 25. Feb 2013 at 17:01:37 +, Giovanni Manghi wrote: I found the overall performances very slow if compared to PostGIS, but I'm not really sure it was qgis fault. Are you using integer primary keys? I'm waiting for the cisco vpn client for win64, then I'll do more

Re: [Qgis-developer] oracle performances

2013-02-26 Thread Giovanni Manghi
Hi Jurgen, Are you using integer primary keys? right now I have difficulties accessing the VPN but at least they gave me the structure of one of the tables I tested CREATE TABLE QGIS_TEST.SEDI_ELETTORALI (OBJECTID NUMBER(38,0) NOT NULL ENABLE, NOME_SEDE VARCHAR2(50 BYTE),

Re: [Qgis-developer] oracle performances

2013-02-26 Thread Jürgen E . Fischer
Hi Giovanni, On Tue, 26. Feb 2013 at 17:54:13 +, Giovanni Manghi wrote: Are you using integer primary keys? right now I have difficulties accessing the VPN but at least they gave me the structure of one of the tables I tested CREATE TABLE QGIS_TEST.SEDI_ELETTORALI ( OBJECTID

[Qgis-developer] oracle performances

2013-02-25 Thread Giovanni Manghi
Hi all, I have been asked to make some test with the new Oracle support and I have been granted access to a DB, but before I had to connect to a (Cisco) VPN. I found the overall performances very slow if compared to PostGIS, but I'm not really sure it was qgis fault. Any feedback? cheers! --

Re: [Qgis-developer] oracle performances

2013-02-25 Thread Jürgen E . Fischer
Hi Giovanni, On Mon, 25. Feb 2013 at 17:01:37 +, Giovanni Manghi wrote: I found the overall performances very slow if compared to PostGIS, but I'm not really sure it was qgis fault. Are you using integer primary keys? Jürgen -- Jürgen E. Fischer norBIT GmbH Tel.