On Thursday 12 February 2004 19:32, Jason Tesser wrote:
> Hi
>
> > Is there an index on:
> > testclass.classid
> I created the indexes and it speed up a little. Still a little slower
> than Access though. Which I think should not be. The testclass is a view
> not A query so I cannot make an ind
On Thu, 12 Feb 2004, Jason Tesser wrote:
> Hi
>
> > > I have the below query written. I have removed a lot from the
> select
> > > Statement for simplicity sake. The query takes way too long.
> > > I am moving from an Access backend to a Postgres back with
> > > Access in the front. The below
> -Original Message-
> From: Jason Tesser [mailto:[EMAIL PROTECTED]
> Sent: Thursday, February 12, 2004 10:03 AM
> To: [EMAIL PROTECTED]
> Subject: [GENERAL] help with query speed
>
>
> I have the below query written. I have removed a lot from the select
&g
> You didn't answer my question about whether they are the same types.
Are
> they?
Yes but testclass is a view. But the field it is referencing is of the
same type.
---(end of broadcast)---
TIP 7: don't forget to increase your free space map set
On Thu, 12 Feb 2004, Jason Tesser wrote:
> I have the below query written. I have removed a lot from the select
> Statement for simplicity sake. The query takes way too long.
> I am moving from an Access backend to a Postgres back with
> Access in the front. The below query is taking like 14-20
Hi
> > I have the below query written. I have removed a lot from the
select
> > Statement for simplicity sake. The query takes way too long.
> > I am moving from an Access backend to a Postgres back with
> > Access in the front. The below query is taking like 14-20 seconds.
> > Is their a bette
I have the below query written. I have removed a lot from the select
Statement for simplicity sake. The query takes way too long.
I am moving from an Access backend to a Postgres back with
Access in the front. The below query is taking like 14-20 seconds.
Is their a better way I can write the j
