ansaurus

Question

Persistent database connection for Ajax Calls

Answer 1

A:

It sounds like you need connection pooling, where a set of connections is always maintained for clients. It reduces the overhead of opening a new connection. You would normally not have a connection per client, but a set of connections configured for a number of simultaneously requesting clients.

See here for more details on mysql_pconnect and here for a related SO question.

Brian Agnew 2010-09-11 13:56:44

Answer 2

A:

You can use mysql_pconnect (http://www.php.net/manual/en/function.mysql-pconnect.php) which creates a persistent connection to the database.

halfdan 2010-09-11 13:57:17

Thanks so much. ! Works like charm.

Codex73 2010-09-11 14:01:52

No! But this is not necessary, pconnect help you to minimize the overhead you'd have if you created a new connection to the DB every time. mysql_select_db doesn't produce any noticeable overhead. You still need to have pconnect/select_db every time your script is being executed.

halfdan 2010-09-11 14:04:35

Super! I also saw on the manual link that we can include the select as part of query thus eliminating the function call. Something like this: mysql_query('SELECT * FROM database_name.table_name'); http://php.net/manual/en/function.mysql-select-db.php

Codex73 2010-09-11 14:07:32

Of course that works, but if you have a lot of queries you might not want to prepend the database name in the query as it might get very ugly to handle if your database name changes (new install e.g.).

halfdan 2010-09-11 14:12:14

Great Thanks!!!

Codex73 2010-09-11 14:27:26

ansaurus

tags:

views:

answers:

Persistent database connection for Ajax Calls

related questions