FUDforum: comp.lang.php » Mysqli or PDO Persistent prepared statements

Home » Imported messages » comp.lang.php » Mysqli or PDO Persistent prepared statements

Show: Today's Messages :: Polls :: Message Navigator

Re: Mysqli or PDO Persistent prepared statements [message #183646 is a reply to message #183644]

Wed, 06 November 2013 10:45

Jerry Stuckle
Messages: 2598
Registered: September 2010

Karma:

Senior Member

On 11/6/2013 4:18 AM, Ram wrote:
> I have a very high traffic server. Getting upto a million hits per day.
> These are basically tracking URLs that log the hits and redirect to the relevant page
>
> The current script using php mysql is very slow. I want to switch to mysqli.
> Are there any basic guidelines for shifting to mysqli
> Can I use a persistent prepared statements across different calls to the web server ?
>
> Thanks
> Ram
> Spammers please visit http://pragatee.com
>

You're not going to see any significant gain by switching from
mysql_xxx() to mysqli_xxx(). Both use similar interfaces, and the
overhead is about the same.

Prepared statements are good, but they will slow you down even more as
each one requires multiple calls to the database code. MySQL has no
such thing as "persistent prepared statements" (neither does anyone else
AFAIK).

Have you determined your MySQL calls are the problem? Or are you
shooting in the dark?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================

Report message to a moderator

[Message index]

		Mysqli or PDO Persistent prepared statements By: ram on Wed, 06 November 2013 09:18
		Re: Mysqli or PDO Persistent prepared statements By: The Natural Philosoph on Wed, 06 November 2013 09:46
		Re: Mysqli or PDO Persistent prepared statements By: Jerry Stuckle on Wed, 06 November 2013 10:45
		Re: Mysqli or PDO Persistent prepared statements By: Tobiah on Wed, 06 November 2013 17:41
		Re: Mysqli or PDO Persistent prepared statements By: Thomas 'PointedEars' on Wed, 06 November 2013 19:25
		Re: Mysqli or PDO Persistent prepared statements By: Beauregard T. Shagnas on Wed, 06 November 2013 22:06
		Re: Mysqli or PDO Persistent prepared statements By: Arno Welzel on Wed, 06 November 2013 20:04

Previous Topic:	detection of 2d array?
Next Topic:	another value passing problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 18 04:59:33 GMT 2024

Total time taken to generate the page: 0.04537 seconds