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
