pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedSlow Recordset
3+ messages / 2 participants
[nested] [flat]
* Slow Recordset
@ 2000-05-04 20:35 Francisco Jose Toledano Alcala <ftoledano@retemail.es>
0 siblings, 1 reply; 3+ messages in thread
From: Francisco Jose Toledano Alcala @ 2000-05-04 20:35 UTC (permalink / raw)
To: pgsql-interfaces
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)
Please, I need help as soon as posible.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Slow Recordset
@ 2000-05-04 23:37 Joe Shevland <shevlandj@kpi.com.au>
parent: Francisco Jose Toledano Alcala <ftoledano@retemail.es>
0 siblings, 1 reply; 3+ messages in thread
From: Joe Shevland @ 2000-05-04 23:37 UTC (permalink / raw)
To: Francisco Jose Toledano Alcala <ftoledano@retemail.es>; +Cc: pgsql-interfaces
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.
Can you execute the query on the server using 'psql' and compare
results?
Joe
>
> Please, I need help as soon as posible.
--
Joe Shevland
Principal Consultant
KPI Logistics Pty Ltd
http://www.kpi.com.au
mailto:shevlandj@kpi.com.au
"Support bacteria -- it's the only culture some people have!"
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Slow Recordset
@ 2000-05-05 16:04 Joe Shevland <shevlandj@kpi.com.au>
parent: Joe Shevland <shevlandj@kpi.com.au>
0 siblings, 0 replies; 3+ messages in thread
From: Joe Shevland @ 2000-05-05 16:04 UTC (permalink / raw)
To: Francisco Jose Toledano Alcala <ftoledano@retemail.es>; +Cc: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2000-05-05 16:04 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-05-04 20:35 Slow Recordset Francisco Jose Toledano Alcala <ftoledano@retemail.es>
2000-05-04 23:37 ` Joe Shevland <shevlandj@kpi.com.au>
2000-05-05 16:04 ` Joe Shevland <shevlandj@kpi.com.au>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox