From: Francisco Jose Toledano Alcala <ftoledano@retemail.es>
To: pgsql-interfaces@postgresql.org
Subject: Slow Recordset
Date: Thu, 04 May 2000 22:35:30 +0200
Message-ID: <3911DF11.4FBD054F@retemail.es> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: ftoledano@retemail.es
Subject: Re: Slow Recordset
In-Reply-To: <3911DF11.4FBD054F@retemail.es>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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