faster way to provide data

I use a custom data provider and the event OnRetrieveDayEvents to supply Event Objects with Version 12.0.1

1) I do some queries in each call of  OnRetrieveDayEvents, but this is very slow if you are in a MonthView  ->  ist would be faster do provide all Events object of at least the current month in one bunch (one database query)

 Questions:
  Is there a better way to supply the data?
  or
  can I preload the data -> if yes which event should I use?

Regards

Alex
 
 

Yes, OnRetrieveDayEvents is the handler of XTP_NC_CALENDAR_DoRetrieveDayEvents:


I would like to avoid caching, because my application works in a multiuser environment with a lot of event changes.
It would be a great help to know, when the view will be updated f.ex. the month view starts a series of calls to event XTP_NC_CALENDAR_DoRetrieveDayEvents. So when the first call to XTP_NC_CALENDAR_DoRetrieveDayEvents occurs i could prefetch records of the next 7 or 30 days.

Any idea how to achieve that?

Well its not that complicated
Appointments and Tasks are saved in a central database (simple client -server). Each client can add own appointments but also set appointments for other persons (also delete and change). So each client must poll (query) for new appointments and events. We use some sophisticated mechanisms for that task and also some internal data structures for saving recurrences. We read simple appointments on demand directly from database to reduce memory consumption.

Our application has the ability to show calendars of multiple persons. So if we would add all visible events to cache  -> this would take too long and consume too much memory.

So we would like to use that calendar control only for display. We do not need the data management. So if we would have an event, when the user changes the view and when  the user changes the day within the day view, we could add all visible events to cache and remove them before a new update of the view occurs.


Regards

Alex,
can you please give some further implemention details, cause we are having exactly the same problem.
Remote database, lot of entries, client/server model, changing data in background...

Regars, Marco

Hi !

I have a single Datasource that queries all visible Appointments for all users (users determined by filter).
The only special thing we use is, that we do not query for only one day, which is  too slow in the month view. We have our own cache that feeds the normal OnRetrieveDayEvents.

So if OnRetrieveDayEvents occurs, we first  check whether our cache contains the events. If not, we do the query and feed our cache.

Hope that helps :-)