0
Undo
Votes
Hello !! For our large scale EventCalendar we are tryping to optimize jEvents, and strip out the internal event multiplication for repeats. The approach is to add extra attributes for the Dates on which the event occurs, and save the dates in a seperate database table.
Basically we need a list-view, that displays a set of events which we "selected" from the database. So i need to edit the query (dynamically of course) which would be the base for the displayed events. Do you have any documentation which would help me out to realize this?
-
ALSO we need to have the MAP, which shows a specific event-set, based on a manual sql-query, which is maybe the same kind of hack !!
best regards, Michael Strasser
Basically we need a list-view, that displays a set of events which we "selected" from the database. So i need to edit the query (dynamically of course) which would be the base for the displayed events. Do you have any documentation which would help me out to realize this?
-
ALSO we need to have the MAP, which shows a specific event-set, based on a manual sql-query, which is maybe the same kind of hack !!
best regards, Michael Strasser
Hi Michael - we do store the repetitions and exceptions in a separate database table to the event desciptions and titles etc.
Or are you thinking of a table with a table of all possible dates with references to the events that occur on them. If so I have experimented with this approach to optimising the database queries but didn't find it any faster
The base table is the vevent table, details are in the details table, repetitions in the repetitions table, rrule in the rrule table, exceptions in the exceptions table - the field names should allow you to generate the joins you need. For an example take a look at the components/com_jevents/libraries/dbModel.php file
If you do find a faster way to generate the list of events that fall within a time window I would be very interested in testing out your code.
Or are you thinking of a table with a table of all possible dates with references to the events that occur on them. If so I have experimented with this approach to optimising the database queries but didn't find it any faster
The base table is the vevent table, details are in the details table, repetitions in the repetitions table, rrule in the rrule table, exceptions in the exceptions table - the field names should allow you to generate the joins you need. For an example take a look at the components/com_jevents/libraries/dbModel.php file
If you do find a faster way to generate the list of events that fall within a time window I would be very interested in testing out your code.
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!
- Page :
- 1
There are no replies made for this post yet.