From: | Joel Burton <joel(at)joelburton(dot)com> |
---|---|
To: | "Adler, Stephen" <adler(at)bnl(dot)gov> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: its really SLOW!!!!! |
Date: | 2002-12-02 21:56:22 |
Message-ID: | 20021202215622.GA15740@temp.joelburton.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Mon, Dec 02, 2002 at 04:43:18PM -0500, Adler, Stephen wrote:
> oh boy, I now realize how little I know about databases...
> OK, so I'm switching from MySQL to postgresql. I have
> this database in MySQL which used the enum data type,
> which looks to be a MySQL extension since there are no
> enum data types in postgresql. What I do is store a bunch
> of values of the setting of a magnet and I have about 6
> entries per master record number. (i.e. I have a table
> which I call the master table, one row entry per master record,
> one table called the magnet table, which has many entries
> per Master record entry.)
> So what I do is loop over the master record entries, say
> record numbers 5000-5300, and for each master record entry,
> I look up in the magnet table data stored for that master
> record. The deal is this, its really slow pulling out the
> data from the magnet table. Like 15 seconds for 500 selects.
> The equivalent select in MySQL ran at least 10 times faster.
>
> Any ideas of what I'm doing wrong? Did I give you guys
> enough information so that you understand what I'm doing?
Steve --
Why don't you post a dump of the create statements for your table, and
the select statement that you think is running so slowly?
--
Joel BURTON | joel(at)joelburton(dot)com | joelburton.com | aim: wjoelburton
Independent Knowledge Management Consultant
From | Date | Subject | |
---|---|---|---|
Next Message | Adler, Stephen | 2002-12-02 22:11:45 | Re: its really SLOW!!!!! |
Previous Message | Adler, Stephen | 2002-12-02 21:43:18 | its really SLOW!!!!! |