Message-ID: <3912F118.8C354300@kpi.com.au>
Date: Sat, 06 May 2000 02:04:40 +1000
From: Joe Shevland <shevlandj@kpi.com.au>
Organization: KPI Logistics Pty Ltd
MIME-Version: 1.0
To: Francisco Jose Toledano Alcala <ftoledano@retemail.es>
CC: pgsql-interfaces@postgresql.org
Subject: Re: Slow Recordset
References: <3911DF11.4FBD054F@retemail.es> <391209D6.3C3AD382@kpi.com.au>
	<3912E30E.E910897B@retemail.es>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

You could try a clustered index with the CLUSTER command, thoughs there's a few
things worth reading about it first. I don't know that this would really help in
this case though.

Joe

Francisco Jose Toledano Alcala wrote:
> 
> Joe Shevland wrote:
> >
> > Francisco Jose Toledano Alcala wrote:
> > >
> > > Hello everyone.
> > >
> > > I think i've got a big problem developing an client-server aplication.
> > > On Server side I use a postgress sql server  for linux, using SuSe 6.3
> > > distribution, all over a ethernet network with aproxmately 10 clients.
> > > On clients side, i use windows 98 and Visual Basic 6 clients programs
> > > using ADO throught odbc  (postgress odbc driver).
> > >
> > > All run ok. I create a database and 5 tables on Access to export all
> > > throught odbc to Postgress Server. Export work ok, and all registers
> > > apears ok. The primary key is exported correctly too.
> > >
> > > The table has aproximately 15 fields with one of the of type 'text'.
> > >
> > > The i run on Visual a program to fill the database with 50.000 registers
> > > with ADO. All run ok, but when on client run a query like "select * from
> > > alumnos order by codalumno;" over all registers, the query spend aprox.
> > > 35 seconds. The server is a Pentium III, 128 Mb RAM, 8'4 UDMA 66 IDE
> > > disk.
> > >
> > > I think there must be an error on postmaster daemon runing because its
> > > imposible to run as slow as i see.
> > >
> > > Must optimize the database with a view or something like that?
> > > Is this normal?
> > > Need more indexes? (I've only the primary key)
> >
> > Is 'codalumno' the primary key? If not defining an index on this column
> > may speed things up.
> >
> 
> Yes, it's primary key.
> 
> > Can you execute the query on the server using 'psql' and compare
> > results?
> >
> Timing results are executed on server side throught psql.

-- 
Joe Shevland
Principal Consultant
KPI Logistics Pty Ltd
http://www.kpi.com.au
mailto:shevlandj@kpi.com.au