how to increase the performance the select query

[Damodhar]

hi

any one give the details about the following things:

how to increase the performance the mysql select query??
whats the maximum parameters allowed in mysql functions
how to find if the session is start or not. when will the session is
start,
what is PEAR why we are used.
what is functionality if UTF-8

[Rik Wasmus]

Re: how to increase the performance the select query

On Fri, 08 Feb 2008 23:13:58 +0100, Damodhar <damu.be@gmail. comwrote:

hi
>
any one give the details about the following things:
>
how to increase the performance the mysql select query??

ask in comp.databases. mysql

whats the maximum parameters allowed in mysql functions

ask in comp.databases. mysql

how to find if the session is start or not.

$session_starte d = !empty(session_ id());

when will the session is
start,

Please elaborate, I don't know what you mean.

what is PEAR why we are used.

http://pear.php.net, because it's easier then to code from scratch.

what is functionality if UTF-8

As good as equal, you might want to check for multibyte safety of
functions though, and possible use one of the mb_*() functions instead.
--
Rik Wasmus

[The Natural Philosopher]

Re: how to increase the performance the select query

Damodhar wrote:

hi
>
any one give the details about the following things:
>
how to increase the performance the mysql select query??

Deepnds on te query.

Write the query several different ways if its complex, Add indices to
the files.

whats the maximum parameters allowed in mysql functions

what is a maxiumumparamet er?

how to find if the session is start or not. when will the session is
start,
what is PEAR why we are used.

No idea. I grow peras to eat. They make good pies.

what is functionality if UTF-8
>

Its about as near as you can get to a generic character set that handles
western characters.

>
>