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]
..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?
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 ..
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?