From: | Grzegorz Przedziecki <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
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? |