note 111344 added to function.mysql-connect

From: Date: Sat, 09 Feb 2013 12:09:37 +0000
Subject: note 111344 added to function.mysql-connect
Groups: php.notes 
Request: Send a blank email to php-notes+get-193567@lists.php.net to get a copy of this message
If you still have a code that uses MySql (instead of MySqlI) then you can use this program that convert our php code into mysqlI. https://wikis.oracle.com/display/mysql/Converting+to+MySQLi While the code is old, it still works fine (with some minor details for example set_charset). However, the migration from MySql to MySqlI could generate some performance hit, at least for windows. I did some benchmark using a local website (windows server & apache & php 5.4 with apc) and it shows: 10 concurrent instances, 300 iteration per instance (less is better). MySql = 23.03 milliseconds (per page). MySqlI = 25.3 milliseconds (per page). 30 concurrent instances, 100 interaction per instance (less is better). MySql = 48.3 milliseconds (per page). MySqlI = 53.6 milliseconds (per page). ---- Server IP: 69.147.83.199 Probable Submitter: 190.162.98.84 ---- Manual Page -- http://php.net/manual/en/function.mysql-connect.php Edit -- https://master.php.net/note/edit/111344 Del: integrated -- https://master.php.net/note/delete/111344/integrated Del: useless -- https://master.php.net/note/delete/111344/useless Del: bad code -- https://master.php.net/note/delete/111344/bad+code Del: spam -- https://master.php.net/note/delete/111344/spam Del: non-english -- https://master.php.net/note/delete/111344/non-english Del: in docs -- https://master.php.net/note/delete/111344/in+docs Del: other reasons-- https://master.php.net/note/delete/111344 Reject -- https://master.php.net/note/reject/111344 Search -- https://master.php.net/manage/user-notes.php

« previous php.notes (#193567) next »