| 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: | Whole Thread | Raw Message | 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? |