All,

Further to my last post: it's worth pointing out that following Blah's example, I have increased the number of rows in the dbo.Books table considerably to test this.

I used the...

Henrik,

Many thanks for your response.

I've played around with indexing strategies with my "Latest Edition" example using the dbo.Books table, and nothing is really helping.

The strange thing is that from an...

Thanks for your post Blah Baby.

It seems that the Row_Number() clause is the cause of the slow running, rather than the CTE itself.

(Worrying given the subject of my article was...

Anye,

Thanks for posting a follow up.

It sounds like any useful findings you gather could form the basis for an interesting CTE article. 😉

With regards,

Lawrence.

Anye,

Many thanks for your post.

It's news to me that the performance of a CTE query is based on the number of columns in the "Outer" query.

Rather, CTEs are generally very...

Martin,

Unfortunately I don't know much about MySQL as my background is MS SQL Server.

However, you can definitely use stored procedures:

http://www.mysqltutorial.org/introduction-to-sql-stored-procedures.aspx

As for Row_Number() type functionality, I don't know if...