Re: [Zope] Calender Tag SQL caching
Arjan Scherpenisse wrote: Hi everybody, This is my first posting to this list. I have a website which will make use of a calender, with events on it stored in a MySQL database. Now, i wondered how to efficiently show this data from the database in the calender. I mean, not in a way that a sql query is made for each day on the calender (which would make up to 31 queries in the Calender Tag 'month' view...) So i wondered, is there some way to 'cache' the result of the SQL method, so that i can use just one query to fill up an entire month, for instance? welcome to zopeland. SQL methods automatically cache themselves (check the advanced screen under /manage of the SQL method in question). unless you're passing in different arguements for each day, in which case you're probably better off retrieving all the calendar events at once you should have to worry about it. if you have any questions how, send me a copy of the schema for the tables. there is a tradeoff for ram but unless you have a large calendar it shouldn't make a difference. cheers Kapil regards, -- Arjan Scherpenisse [EMAIL PROTECTED] may the source be with you === http://www.gnu.org === ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev ) ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Calender Tag SQL caching
Arjan Scherpenisse wrote: Hi everybody, This is my first posting to this list. I have a website which will make use of a calender, with events on it stored in a MySQL database. Now, i wondered how to efficiently show this data from the database in the calender. I mean, not in a way that a sql query is made for each day on the calender (which would make up to 31 queries in the Calender Tag 'month' view...) So i wondered, is there some way to 'cache' the result of the SQL method, so that i can use just one query to fill up an entire month, for instance? welcome to zopeland. SQL methods automatically cache themselves (check the advanced screen under /manage of the SQL method in question). unless you're passing in different arguements for each day, in which case you're probably better off retrieving all the calendar events at once you should have to worry about it. if you have any questions how send me a copy of the schema for the tables. there is a tradeoff for ram but unless you have a large calendar it shouldn't make a difference. cheers Kapil regards, -- Arjan Scherpenisse [EMAIL PROTECTED] may the source be with you === http://www.gnu.org === ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev ) ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] Calender Tag SQL caching
Hi everybody, This is my first posting to this list. I have a website which will make use of a calender, with events on it stored in a MySQL database. Now, i wondered how to efficiently show this data from the database in the calender. I mean, not in a way that a sql query is made for each day on the calender (which would make up to 31 queries in the Calender Tag 'month' view...) So i wondered, is there some way to 'cache' the result of the SQL method, so that i can use just one query to fill up an entire month, for instance? regards, -- Arjan Scherpenisse [EMAIL PROTECTED] may the source be with you === http://www.gnu.org === ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Calender Tag SQL caching
On Mon, 31 Jul 2000, Arjan Scherpenisse wrote: Hi everybody, This is my first posting to this list. I have a website which will make use of a calender, with events on it stored in a MySQL database. Now, i wondered how to efficiently show this data from the database in the calender. I mean, not in a way that a sql query is made for each day on the calender (which would make up to 31 queries in the Calender Tag 'month' view...) So i wondered, is there some way to 'cache' the result of the SQL method, so that i can use just one query to fill up an entire month, for instance? hi have a look at CachePool at the download page. it cached based on URL1 and query string. it may or may not help you regards, -- Arjan Scherpenisse [EMAIL PROTECTED] may the source be with you === http://www.gnu.org === ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev ) -- -- http://www.kedai.com.my/kk Am I Evil? ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )