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?


Quote Reply
Re: Speed optimization? In reply to
This might not be the best solution, but it seems that your pages have to keep drawing many tables to display your data, which will slow down the output.

You might want to reconfigure your database output so that you use line break tags and paragraph breaks rather than so many table cells to display the output.

Hope this helps

Unoffical DBMan FAQ
http://webmagic.hypermart.net/dbman/
Quote Reply
Re: Speed optimization? In reply to
The tables are not the problem (except when rendering the finished page with IE, which is a known problem), because there still is this vast speed difference between "retrieve all ID's at once" or "retrieve piece by piece" when using the same html template for both queries (identical html output).