Slow Database [Solved]

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Slow Database [Solved]

Postby erzon » 08. March 2013 20:16

I just downloaded the latest version of XAMPP. Before I installed the old version and I don't have any problem.. but when I installed the latest version it seems the query in database seems take a little bit slow especially in select option... Where do i need to adjust in order to resolved the problem?
erzon
 
Posts: 22
Joined: 12. May 2012 05:26
Operating System: Windows 7

Re: Slow Database

Postby erzon » 09. March 2013 03:45

anyone have thoughts to fix this?
erzon
 
Posts: 22
Joined: 12. May 2012 05:26
Operating System: Windows 7

Re: Slow Database

Postby Altrea » 09. March 2013 14:02

We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: Slow Database

Postby erzon » 09. March 2013 14:33

My case is different... the slow database only occur in select option area... when I edit the record with normal textarea or text it can query database with no problem but if the query include the form with select option then the problem occur. the query delay almost 5 secs before it shows the record. But with same code I didn't encounter this in older version... so I don't know what settings I need to change in order to avoid this
erzon
 
Posts: 22
Joined: 12. May 2012 05:26
Operating System: Windows 7

Re: Slow Database

Postby Altrea » 09. March 2013 15:01

erzon wrote:the slow database only occur in select option area... when I edit the record with normal textarea or text it can query database with no problem but if the query include the form with select option then the problem occur.

The Database and PHP don't know anything about any webform elements like select fields, check or text fields. They don't separate where the data come from.
Please provide a full code example + database schema with some example data so that anybody can analyse the problem hisself.
Otherwise nobody will be able to help you.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: Slow Database

Postby erzon » 09. March 2013 15:26

Sorry.. your right... I change the bind address to 127.0.0.1 in mysql settings but I forgot to change the connection settings in my script from localhost to 127.0.0.1 it seems the problem has been solved already sorry for the misunderstanding
erzon
 
Posts: 22
Joined: 12. May 2012 05:26
Operating System: Windows 7

Re: Slow Database

Postby Altrea » 09. March 2013 15:28

Glad you got it working :D
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 144 guests