speed Databases &amp;&amp; PHP

speed Databases && PHP

Hi I\'ve 2 questions:

1) I need more speed for my pages PHP because It uses more \"SELECTS\" in DB. How do it?

2) How create only one connection with a DB. for all my PHP pages? (With this connection I\'ll do all my sql-executions)

Thanks

Read the articles on phpbulider about database and query optimizations.

ok
but, can you tell me the URLs, please?

(I read some articles but don't help me)

Sure, how about mysql.com - read their documentation - it is an excellent source.

Real brief
to optimize queries - use indexing (software side)
to have one connection use mysql_pconnect();