I have one recordset called rsNews. On my page I have 3 different coloms. One for Teamnews, the second for personal news, and the third for Normal news. I want to get these three types of news selected out of the same database colom, and sorted exactly as shown above.

In the recorset rsNews i don't use a filter, on the webpage i use three different repeat regions. Besides every repeat region i tried to use the Conditional Region, but that didn't work out with one recordset for 3 repeat regions / conditional regions.

Who can help me out with this ?

This might not be the MOST EFFICIENT way of doing it, but why not have THREE different recordsets?

RSTeamnews
RSPersonalnews
RSNormalnews

Use a filter in each recordset.

When in doubt...reboot!

I thought that if you have more than 4 recordset's on your page it's badly for the speed of your page blah blah blah.....but this doesn't matter ?

If it's not than i think what you proposed is the most simpelst

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I thought that if you have more than 4 recordset's on your page it's badly for the speed of your page blah blah blah.....but this doesn't matter ?

If it's not than i think what you proposed is the most simpelst
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Niet teveel stressen <img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>

Why go with the hard way when you can do it easier, I would also recommend going with 3 queries, depending on the type of application server, the server load becomes only noticable if you use more then 10 queries.

I made one with 24 queries and it loads pretty fast on my own system.
And when I asked people to test it, i only got one complaint, he only got half the page, but that was because the nr of people testing it went beyond the sessions my server could handle, that was PWS on win98, now with IIS5 on win2k I'm still waiting for the first complaint about that page.

Editing it is a entirely different matter, UDev almost slows to a complete stop after every change i make to that page.

With kind regards,

Dennis van Galen
Webmaster KPN Nederland
Financial and Information Services

To djvgalen:

It's true that you can insert as many recordsets as you want and that it will load fast when somebody is testing it. But try to imagine what would happen if that page has more visitors (let's say 1.000+ a day). It would be noticably slower. Everything matters (the way you wrote the code, number of recordsets, type of DB...) and it's better to optimise code at the very beginning then when site starts getting hits.
Keep in mind that UD creates 'fit-for-all' code that's everything but not optimised.

Viktor Farcic

TalkZone Manager

I agree Viktor, it's also worth noting that developing for high traffic sites you should keep everything to a minimum, try using variables instead of querying based on a session, things like that will keep heavy bandwidth sites loading smoothly.

But sometimes, and i was assuming this was one of those times, it's better to opt for 3 queries instead of spending 3 days to perfect the process with just 1 query and constantly getting lost in the code-view.

With kind regards,

Dennis van Galen
Webmaster KPN Nederland
Financial and Information Services