Slow write to DB but read Ok?

Seoman · Post by **Seoman** » Tue May 16, 2006 3:59 pm

Script URL: http://intranetgjl/hesk (it's installed to be local)
Version of script: 0.93
Version of PHP: 4.3.2
Hosting company: Myself using a RH enterprise 3.0
Have you searched THIS FORUM for your problem: Yes
(if not please do before posting)
If so, what terms did you try: Nothing I found relates to my problem.

Write your message below:

Hi, I've succesfully solved my login bug (the same issue that plagues a lot of people, unfortunately.) but i'm still stuck with a bug to which I haven't seen any solution either in the forum or the internet in general. Here's how it goes:

I'm hosting my helpdesk as a sub-part of my intranet (meaning i've copied the Hesk folder into the root of my intranet.). I already have a MySQL database running for my intranet and I've created another one for Hesk using the installer file. Everything works fine when I try to add entries in my intranet DB but when I try to add something (let's say a ticket) using Hesk, it takes a long time before completing the operation, about a couple of minutes... Also, whenever I try to read from the DB, everything's ok I get normal speeds. And by the way, the intranet database is extremely small and there are only a couple of entries in my Hesk database. Any ideas as to what may be causing the problem?

Thanks.

Post by **Klemen** » Tue May 16, 2006 7:27 pm

No idea what could be wrong, but it must have something to do with your server setup, because there is nothing special in Hesk SQL code. Do other PHP scripts with MySQL have such problems?

Seoman · Post by **Seoman** » Wed May 17, 2006 2:18 am

Thanks for the swift reply.

That's the thing, MySql hosts two DBs: my intranet and Hesk. Whenever I add things to my intranet DB, everything's ok, but when I'm using the Hesk one, it's slow...

I'll try to look deeper into it tomorrow.

thanks

Post by **Klemen** » Wed May 17, 2006 1:15 pm

Maybe something to do with database user/permissions? I'm not a server-side expert so I don't really know what to suggest here, sorry.

Seoman · Post by **Seoman** » Wed May 24, 2006 12:50 pm

Just to give you a little follow up, I've finally decided to install Hesk on my own desktop which will constantly run EasyPHP.

Thanks for the support and dedication, guys like you make the internet a place worth visiting.

[Seoman]