Hello all,

I was wondering, i made an event calendar that displays a month (dynamic). In the calendar loop <font size=2>(For Row = 0 to 5 response.write "&lt;TR&gt;" For Col = 0 to 6 .... Next response.write "&lt;/tr&gt;" Next %&gt; </font id=size2> i placed a rs so for every day i can check if there's an event for that day. Works great!

BUT....

how about performance. The recordset needs to be called around 30 times every time the page is displayed. No problem if i test it.

But what if 50 other users try it at the same time ?
And how about addeding another rs in the loop?

Is this a bad thing to do?? Because i don't know how to do it otherwise...

I am using SQL-Server 2000...

Thnx in advance



Matthijs
----------------
DWMX/W-XP-PRO/IIS/ASP-VB
www.chaps.nl

I should think SQL Server could easily cope with that.

Regards,
Dave

UD4 || Flash || Access ||Web Hosting

yeah i think so to... takes a little bit longer to load, but wirks fine...

thnx

Matthijs
----------------
DWMX/W-XP-PRO/IIS/ASP-VB
www.chaps.nl