Gossamer Forum
Home : Products : DBMan : Discussions :

Speed optimization?

Quote Reply
Speed optimization?
Hi,

I have a concert calendar database in two languages, and I have now online a page which prints a name of a day, then fetches DB items of that day and sorts them by clock, then prints a name of a day, then fetches DB items of that day and sorts them by clock, then... you get the idea.

Problem here is speed. I have done the page by inserting include virtuals between each day in html file. And it is slow! See

http://www.musicfinland.com/..._database_print.html

and

http://www.musicfinland.com/...rogram_database.html

Page code goes like this....

-------------------------------------------------------
[snip]

Code:
<h3>Friday 27.7.</h3>
..include virtual command here to fetch data ..

<h3>Saturday 28.7.</h3>
..include virtual command here to fetch data ..
[snip]

etc.
-------------------------------------------------------

Now, the question is: can this output form (dayname -items for that day sorted by clock - dayname - items for that day sorted by clock - dayname ...) be done in one call? Because if I make a call

http://www.musicfinland.com/...nd&sb=1&ID=*

even by include virtual, it is very fast. But calling db 10 times in a row is very very slow. I do not want to have each item have a name of the day next to it - I like the way it is now.

Any ideas?


Subject Author Views Date
Thread Speed optimization? Saarinen 2142 Dec 29, 2000, 4:50 AM
Thread Re: Speed optimization?
LoisC 2082 Dec 29, 2000, 8:34 AM
Post Re: Speed optimization?
Saarinen 2073 Dec 29, 2000, 9:39 AM