Re: select slow?

On 30/03/2004 20:25 Jaime Casanova wrote:
> hi all,
>
>
> i have an amd athlon with 256 ram (i know, this is not a *real* server
> but my tables are small)
>
> i'm using vb6 (win98) with pgsql-7.3.4 (rh8) trough the psqlodbc.
>
> when i do a select in took long to execute, here is an example
>
>
> table icc_m_banco
>
> CREATE TABLE ICC_M_BANCO (
> CodBanco SMALLINT NOT NULL,
> Descripcion CHARACTER VARYING(60) NOT NULL,
> RefContable NUMERIC,
> Estado CHAR(1) NOT NULL,
> FecRegistro DATE NOT NULL,
> CONSTRAINT EstadoBanco CHECK ((Estado = 'A') or (Estado = 'I')),
> PRIMARY KEY(CodBanco)
> );
>
>
> select * from icc_m_banco where codbanco = 1;

select * from icc_m_banco where codbanco = 1::int2;

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for
Business |
| Computer Consultants |
http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+