Hi,

Can anyone suggest a better way to building an Event Calendar?

So far I'm doing the following on a page:


Loop Through dates  (entire month)
   Loop Through hours
      Display any events
   Close Loop
Close Loop

This is V.Slow when there are more than 2 events per date.
How can I make this quicker, and show those dates with no events so far?


Cheers
Craig.
	
	

_____________________________________________________________________
Kingfield Heath Ltd. Email Disclaimer

Confidentiality : This email and its attachments are intended for the
above-named only and may be confidential. If they have come to you in
error you must take no action based on them, nor must you copy or
show them to anyone; please reply to this email and highlight the
error.

Security Warning : Please note that this email has been created in
the knowledge that the internet is not a 100% secure communications
medium. We advise that you understand and observe this lack of
security when emailing us.

Viruses : Although we have taken steps to ensure that this email and
attachments are free from any virus, we advise that, in keeping with
good computing practice, the recipient should ensure they are
actually virus free.
_____________________________________________________________________

I would order your events in ascending order.

Then, you can check to see when the first event is. Create all the HTML up
until the first event, then write out the first event. Check to see if the
next event is also at the same time, if so, write it out. If not, write out
HTML until next event.

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Craig Flannigan" <ckf@k...>
Subject: [asp_databases] Planner/Calendars


: Hi,
:
: Can anyone suggest a better way to building an Event Calendar?
:
: So far I'm doing the following on a page:
:
:
: Loop Through dates  (entire month)
:    Loop Through hours
:       Display any events
:    Close Loop
: Close Loop
:
: This is V.Slow when there are more than 2 events per date.
: How can I make this quicker, and show those dates with no events so far?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Thanks Ken.

Why is it running so slow though?
It's a quick server, and my code isn't heavy on it.

I was told that IE will wait until the full table is processed before
displaying.

Any ideas as to how I can improve performance?
So far I haven't even added the Database code yet as it's slow enough as it
is!

Cheers
Craig.


-----Original Message-----
From: Ken Schaefer [mailto:ken@a...]
Sent: 08 November 2002 03:36
To: ASP Databases
Subject: [asp_databases] Re: Planner/Calendars


I would order your events in ascending order.

Then, you can check to see when the first event is. Create all the HTML up
until the first event, then write out the first event. Check to see if the
next event is also at the same time, if so, write it out. If not, write out
HTML until next event.

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Craig Flannigan" <ckf@k...>
Subject: [asp_databases] Planner/Calendars


: Hi,
:
: Can anyone suggest a better way to building an Event Calendar?
:
: So far I'm doing the following on a page:
:
:
: Loop Through dates  (entire month)
:    Loop Through hours
:       Display any events
:    Close Loop
: Close Loop
:
: This is V.Slow when there are more than 2 events per date.
: How can I make this quicker, and show those dates with no events so far?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



_____________________________________________________________________
Please contact I.T. Support if you have received this email in error.
This e-mail has been scanned for all viruses by Star Internet.
_____________________________________________________________________


_____________________________________________________________________
Kingfield Heath Ltd. Email Disclaimer

Confidentiality : This email and its attachments are intended for the
above-named only and may be confidential. If they have come to you in
error you must take no action based on them, nor must you copy or
show them to anyone; please reply to this email and highlight the
error.

Security Warning : Please note that this email has been created in
the knowledge that the internet is not a 100% secure communications
medium. We advise that you understand and observe this lack of
security when emailing us.

Viruses : Although we have taken steps to ensure that this email and
attachments are free from any virus, we advise that, in keeping with
good computing practice, the recipient should ensure they are
actually virus free.
_____________________________________________________________________

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Craig Flannigan" <ckf@k...>
Subject: [asp_databases] Re: Planner/Calendars


: Thanks Ken.
:
: Why is it running so slow though?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

...have you identified which part is slow?

Is it the looping code? Is the code out output results (for example are you
concatenating a large string together)? Is it a browser rendering issue?

Use this to work out what is taking the longest amount of time:
http://www.learnasp.com/learn/speedtimer.asp

Cheers
Ken

It's the rendering.

Even on the Server, where no data has to be sent to a client - it's taking
about 4 seconds to render 7 days. The 7 days contain just two events each,
and so far this is hard coded not reading from a database.

I'm not concatenating any strings yet.

I figured it's to do with the <Table> and  </Table> HTML tags. As IE waits
until it sees the last one before rendering.

I wondered if anyone here has overcome this problem?

Cheers.
Craig.


-----Original Message-----
From: Ken Schaefer [mailto:ken@a...]
Sent: 11 November 2002 00:04
To: ASP Databases
Subject: [asp_databases] Re: Planner/Calendars


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Craig Flannigan" <ckf@k...>
Subject: [asp_databases] Re: Planner/Calendars


: Thanks Ken.
:
: Why is it running so slow though?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

...have you identified which part is slow?

Is it the looping code? Is the code out output results (for example are you
concatenating a large string together)? Is it a browser rendering issue?

Use this to work out what is taking the longest amount of time:
http://www.learnasp.com/learn/speedtimer.asp

Cheers
Ken



_____________________________________________________________________
Please contact I.T. Support if you have received this email in error.
This e-mail has been scanned for all viruses by Star Internet.
_____________________________________________________________________



_____________________________________________________________________
Kingfield Heath Ltd. Email Disclaimer

Confidentiality : This email and its attachments are intended for the
above-named only and may be confidential. If they have come to you in
error you must take no action based on them, nor must you copy or
show them to anyone; please reply to this email and highlight the
error.

Security Warning : Please note that this email has been created in
the knowledge that the internet is not a 100% secure communications
medium. We advise that you understand and observe this lack of
security when emailing us.

Viruses : Although we have taken steps to ensure that this email and
attachments are free from any virus, we advise that, in keeping with
good computing practice, the recipient should ensure they are
actually virus free.
_____________________________________________________________________

Can we see the HTML that you are generating?

There's not a lot you can do to speed up browser rendering except by
minimising the amount of HTML you output...

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Craig Flannigan" <ckf@k...>
Subject: [asp_databases] Re: Planner/Calendars


: It's the rendering.
:
: Even on the Server, where no data has to be sent to a client - it's taking
: about 4 seconds to render 7 days. The 7 days contain just two events each,
: and so far this is hard coded not reading from a database.
:
: I'm not concatenating any strings yet.
:
: I figured it's to do with the <Table> and  </Table> HTML tags. As IE waits
: until it sees the last one before rendering.
:
: I wondered if anyone here has overcome this problem?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~