|Subject||Re: how much faster does a "real server" do?|
> You're right, it's nothing like what you need. If you must do thiscursor > instead:
> partitioning, at least avoid SELECT FIRST n SKIP .etc and use a
Ah, ok...I didn't know that would be faster than using "first"
You're probably right; I shall do some restructuring on the
db..creating a result table is the first thing to do and i'm having an
idea how to get rid of some of the more complex links between tables...