Recurring Events for 2 years = slow database

Hi Tuan,
Using EB version 1.4.1 on Joomla 1.5.23.

I created 7 recurring events, each are daily events and last 2 years. By doing this it created 713 entries per event in the database. That's 713 x 7 = 4991 total events written to the database!
Now when I click the Events link in the joomla admin panel it takes forever to load the events list. Sometimes it won't load at all and this makes it hard to work on or edit any events.
My whole database was only 350K before all the events were added. Now it's 13MB.

Is there any way to avoid so many entries being written to the database?
If not, can you suggest anything else?

Thanks,
Mike

Hi Mike

First of all, version 1.4.1 is very old version, so you should upgrade your site to latest version of Events Booking. Where and when you downloaded version 1.4.1 ?

To avoid many entries being written to database, I think you should change the recurring settings so that it only create recurring events in about few months. 2 years are too long for a recurring events.

Tuan

Thank you Tuan. I decided to make each event for 1 year and this has fixed the problem.

I bought the component here on your site in Aug 2011, but my account says it's not eligible for a free upgrade. When I build a new site that needs EB I will buy the new version.

Thanks,
Mike

Well, I take back that it's "OK" now. Not OK.
Creating recurring events for a year (or more) is just not good for the system. Using the Calendar View on a menu item, it takes about 1 minute to load the page.
I have 7 categories, each with 1 recurring event that lasts 1 year. While creating these events I was checking the calendars to see if they were working, and they were. But once I got to creating the 5th recurring event for the year it started to slow. Then when I finally got to my 7th category recurring event it started taking over a minute to load the calendar page. I'm only displaying a single category on a calendar page. 1 event per day.

I understand that creating recurring events for just a few months will help the loading speed, but then I have to re-create them when they expire. What happens if people are registered for the event the day before I have to re-create them??!
The system is not designed correctly for an event that happens "everyday for a year". The program creates an event for each day (recurring events), but this creates a huge sql query every time.

Making recurring events (everyday events) that last more than a few months slows the page loading. And making them for a year almost stops the pages loading!

Not sure what to do now????
I need to create 7 events that run everyday for a year.

We can improve the speed by adding indexes to database tables. Please submit a support ticket sending me cpanel account of your site if it is possible so that I can access to your site database and do it for you .

Tuan

Update : This speed improvement has been updated to version 1.5.3 of Events Booking. So if it is possible, please upgrade your site to this latest version to get it works properly.

Tuan