Slow Planner with MySQL

[jari@softmade.fi]

For some reason my planner is terribly slow.
The database is quite large, about 200-500 events per day needs to show in planner.
I have noticed that NT8 makes a lot of similar queries.

I also did a lot of rows in the Hotdates database.
No problem with the TPS database, maybe the TPS is much faster when searching for a record in this way.

See attachs.

Jari

[attachment deleted by admin]

[Bruce]

I think maybe a small (TPS) example of how you have set up your calendar would be helpful.

>> maybe the TPS is much faster when searching for a record in this way.

TPS can be a lot faster to perform some tasks than SQL is. However in those case we try and build it so it's more SQL friendly.

cheers
Bruce