Yes, please.

Thanks for the info.



Since this sounds like something the developers would have to handle, 
should I - or you - submit this as an enhancement request?

Indexes won't help because listBirthdays() is a generic function that 
does the date comparisons itself.  It fetches all contact objects and 
then checks the birthday dates one-by-one.



To improve speed, we would need to do the date comparisons in the 
backend database.  This means either using a more specific search 
criteria in the call to search() or implementing an optimized 
listBirthday() function in each backend driver.

Thanks for the quick reply.



I did simply create an index by the object_bday field.  It really did 
not make a difference.  Is there something more to it than that?



What I did was issue this command:

ALTER TABLE `turba_objects` ADD INDEX ( `object_bday` )



The resulting lookup was not any faster.



By the way - out of my 700 turba entries, only 25 actually have a 
birthday entry.  Is the listBirthday function reading every turba 
entry?  Do I need to modify the listBirthday function to know 
about/take advantage of this new index?



thanks again,

REALLY great feature!

Sounds like that would definitely help in your case. For now I feel 
like this is best left to individual sites/DBAs and how they organize 
their tables.

I have added the Address Book to my external events on my calendar in 
order to have the birthdays from my address book show on my calendar.



The time to show my calendar went from 1-2 seconds to 15-20 seconds!   
Should an index be built or something else to reduce the significant 
impact this feature has?



I am running the latest CVS code and have about 700 entries in the 
turba_objects table.



thanks,

Michael

This has been implemented in CVS HEAD through the listTimeObjects API. 
For now we only return attributes with the name "birthday" but this 
could easily be extended in the future to return any attributes of a 
date or datetime type.

Should be just the semantics of the label but it would also be nice to 
have Anniversaries, Christenings, or whatever in addition to birthdays.

so maybe now is just the right time to start working on it :D

I wonder how much intercommunication between turba and kronolith is possible.

From my (deliberatly uninvolved) point of view it would be quite easy 
for kronolith to get the birthdates from turba, or am I wrong ?

Don't find me bothering here, I'm just a little nosy :)

Believe it or not, I want to have this for a few years now, but never 
got to it.

Would be nice to have birthdays saved with the contacts and 
automagicaly see them in the Calender :)

BTW: Really nice work so far ! Keep it on !