NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: jari@softmade.fi on June 19, 2014, 09:33:22 PM

Title: Slow Planner with MySQL
Post by: jari@softmade.fi on June 19, 2014, 09:33:22 PM

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]

Title: Re: Slow Planner with MySQL
Post by: Bruce on June 19, 2014, 11:47:40 PM

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