Persistant mysql?

[Azu]

Hello

 

I use mysql_pconnect but still every page gets 8ms loading time added on to it from the mysql_pconnect

 

Is there a way to fix it so that it doesn't have to reconnect every time, so that it won't add to page loading time?

[scarhand]

Hello

 

I use mysql_pconnect but still every page gets 8ms loading time added on to it from the mysql_pconnect

 

Is there a way to fix it so that it doesn't have to reconnect every time, so that it won't add to page loading time?

 

try just using 1 file with a switch and cases for your pages.

[Azu]

I'm sorry I don't understand..

 

How can I use a switch and cases to speed up mysql_pconnect?

[Azu]

?????

[Azu]

Bump..

[jscix]

You shouldn't have that loading time, usually mysql queries are relatively fast.. anyway.. assuming it's just the sql-server lagging.. depending on the kind of data you are retreiving.. grab all the data that your scripts will require on the first connection and set all the data into session variables.

[per1os]

Why are you using pconnect? From what I know it is unnecessary and takes a toll on your server. There is nothing wrong with closing mysql connections and re-opening them on the page call.

 

Using that pconnect, if you had 100 users your site may stop functioning because of it.

 

Unless there is a specific reason for using it I would stray away from it and just use the regular mysql_connect.

[Azu]

I thought that using pconnect instead of normal connect made it so that it doesn't have to keep reconnecting.

 

But either way it adds an extra 8ms to page generation.

 

How can I fix it so that it doesn't have to keep connecting over and over and over and over so that it is just always connected so that there is no more needing to keep connecting and slowing down the page loading every time?

 

And yes 8ms is a lot when the average time it takes to generate the page is ~16ms and there is a lot of traffic.

It would be cutting the load in half if I could get rid of that. Please tell me how I can.

[per1os]

Post some of your code.

 

I use mysql_connect and my page load is very low. It sounds like you are running a lot of unnecessary trips to the database. The goal is to get as much as you can in one query and than use PHP to process it. Also using * is less efficient in defining the column names etc.

 

It sounds like it is more of a coding issue than something that can be solved by using a single connection. Unless you are connecting to remote database server.

[Azu]

Sorry I think I didn't explain it right.

 

What I meant was, the mysql_connect is taking as long as everything else in the page put together. So it is making it take twice as much load.

 

So I am wandering how can I make it so that PHP just stays connected to it so that it doesn't have to keep reconnecting on every page load.

 

I THOUGHT that this was what mysql_pconnect was for but now I think I was wrong because it does not make any differance then using mysql_connect.

 

So ya basically I just want my website to always have a single connection to mysql open all the time so that it doesn't have to keep reconnecting on every page load.

[soycharliente]

Does this help?

 

http://www.phpfreaks.com/phpmanual/page/features.persistent-connections.html

[Azu]

Thanks, I already tried that though and it didn't make a differance..

Try

 

<?$a=array_sum(explode(' ',microtime()));

mysql_connect(localhost,"root","password");

echo'MYSQL connection time:'.round(round(array_sum(explode(' ',microtime()))-$a,5)*1000,1).' milliseconds';?>

 

And then try replacing the mysql_connect with mysql_pconnect and refresh a few times

 

It always takes 8 milliseconds on every page load no matter which one I use T_T please tell me how I can fix it..

[Azu]

Bump

[Azu]

BUMP

[Azu]

bump...................

[Azu]

Bump

[trq]

Unless you know you specifically need mysql_p* (and you dont) don't use them. 8 secons is rediculous but it sounds more a server or network issue rather than something your going to fix in your code.

[rameshfaj]

Was it OK when only using mysql_connect()?How much time did it took?

If the time was comparatively similar then there is no problem with the persistent connection.

But I think persistent connection gives some problem to you in future also.Like too many connections,server refused to establish the connection.

[Azu]

Bump =\

[Azu]

mysql_connect and mysql_pconnect are both doubling the time it takes for my PHP scripts to run.

They take 8ms each no matter what I do.

Please help :X

[trq]

Stop bumping this thread. 8ms is not what I would call an issue, if you think it is, look at the network connection between your webserver and db server. There isn't really anything you can do in your code.

[per1os]

Unless you know you specifically need mysql_p* (and you dont) don't use them. 8 secons is rediculous but it sounds more a server or network issue rather than something your going to fix in your code.

 

It has to be your network, as Thorpe said. Contact the server administrator.

[Azu]

Okay sorry I don't know who to contact though since I'm running this all by myself.

 

But anyways, when all the queries put together take less then 4ms, and it takes PHP about 3MS to process the page not counting the mysql stuff, and 8MS is being wasted on every page generation, that more then doubles server load, meaning less then half as much traffic can be handled.

 

Please tell me how I can fix it so that it doesn't take so (relatively) long.

[per1os]

Okay sorry I don't know who to contact though since I'm running this all by myself.

 

But anyways, when all the queries put together take less then 4ms, and it takes PHP about 3MS to process the page not counting the mysql stuff, and 8MS is being wasted on every page generation, that more then doubles server load, meaning less then half as much traffic can be handled.

 

Please tell me how I can fix it so that it doesn't take so (relatively) long.

 

How good of a computer are you running it on? Process speed, memory what type of OS are you using?

 

Very well what could be happening is you do not have enough memory on your computer to make it work faster.

[drewbee]

The speed shouldn't be affected that much by pconnect. All that does is it tries and uses an existing connection. Your lag will be coming from the database and returning of data, not the inital connection.