My problem

From: Grzegorz PrzeŸdziecki <grzegorz_przezdziecki(at)lupus(dot)waw(dot)pl>
To: pgsql-general(at)postgreSQL(dot)org
Subject: My problem
Date: 1999-07-20 12:09:57
Message-ID: 37946713.FA40EE99@crn.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


If you dont want to help me don't read this.

I'm new in PostgreSQL but I want to lern.

I don't know exactly what make my M$ Access faster.

Example
create table firma ( id int4 unique, data abstime, who varchar(50))

who is first name plus last name;

The table I use with M$ Access.
He have about 65.000 rows.

When I know only last name and want to find the row (by who) it's make
very long time.

I have index for who .
That is may setings in ODBC Driver.

Disable Genetic Optimizer - True
KSQO - True
Recognize Unique index - True
Use Delclare/Fetch - True
Parse Statment - True

Maximum
Text as LongVarChar - True
Bools as Char - True
Cache Size - 20000 :-)
Max Varchar - 254Max longVarchar 8190
Protocol 6.4
Show Column - True

PostgreSQL 6.4.2

Help Me

Browse pgsql-general by date

  From Date Subject
Next Message The Hermit Hacker 1999-07-20 13:24:30 Announcement Sites ... ?
Previous Message Don Yury 1999-07-20 11:40:27 how to determine table?