> seems that by creating a view ( with the query i mentioned before ),
> my
> queries were sped up by roughly 10 seconds... odd odd odd.
>
Not really so odd when you think of everything the backend has to do to
process a query. Parsing, planning, and optimizing (not necessarily in
that order) can be very costly. A view basically skips most of those
three steps.
-DEJ
- Re: [GENERAL] slow queries Thomas Good
- Re: [GENERAL] slow queries Howie
- [GENERAL] Is there a server log???? Jackson, DeJuan
- [GENERAL] Is there a server log???? Jeremy Hansen
- Re: [GENERAL] Is there a server log???? Oliver Elphick
