thx folks,
I pretty much thought version 1 to be the best.
I' wouldn't have known how to carry the result to other pages anyway.
Jan
Hi,
I've got a page with lot's of visitors every day and I sure hope to
get more, so I'm already thinking of performance. This is what I've
got.
Users
I know what you are trying to get at. A full select and a select with
limit have the same query speed, but the full select has to transfer all
of the selected data, where as a limit only transfers the number of
records specified. The more records that match a search, the faster your
limit
Hi,
I've got a page with lot's of visitors every day and I sure hope to
get more, so I'm already thinking of performance. This is what I've
got.
Users select one or more things out of a couple drop down menus,
no big deal. Their selection is than shown, with a limitation of
20 results on the
[snip]
Now comes my question, what is better speaking of performance:
When users go on to the next page, is it better to
provide the select statement again with a different integer for
the limit?
Or is better to do a full select without a limitation on first page.
But than I don't know how