function causing slow load time [ php function ] - KruXoR

php function

function causing slow load time

Posted in php function

459

2:46 am, April 13, 2023

function causing slow load time

i had this function matching a uid using a binary select query. The sites were loading in about 8 full seconds according to my load timer, sometimes up to 12 seconds!

So this was running on old site code, really just a big mess.

But i copied it to another site and tested each function and the sql that ran on them to see which one was causing the lag time.

This query took about 0.03 seconds to return when tested.

SELECT $field_name FROM $table_name where binary $uid_field_name = '$uid' LIMIT 1

I think I added the binary option as it was not selecting the uid correctly, but removing the binary seems to not make any difference to the results, but reduces this query time a lot.

Test site with 8+k pages was loading in:

Page generated in 8.3164 seconds.

Then after removing the binary select query and just using a normal query, the same page is now.

Page generated in 0.2958 seconds.

So makes a large difference, and more depending on the page or record number i think.

PHP

function get_single_by_uid($field_name,$table_name,$uid,$uid_field_name = "uid") {
	global $db;
	$x = "";
	$uid = mysqli_real_escape_string($db, $uid);
	$field_name = mysqli_real_escape_string($db, $field_name);
	$table_name = mysqli_real_escape_string($db, $table_name);
	//$sql = "SELECT $field_name FROM $table_name where binary $uid_field_name = '$uid' LIMIT 1";
	$sql = "SELECT $field_name FROM $table_name where $uid_field_name = '$uid' LIMIT 1";
	$result = $db->query($sql);
	if(!$result) { return false; }
	$x = mysqli_fetch_assoc($result);	
	if(isset($x[$field_name])) {
		return(politeify($x[$field_name]));
	} 
	return false;
}

Posted in php function

459

2:46 am, April 13, 2023

View Statistics

This Week

138

This Month

729

This Year

4816

No Items Found.

Add Comment

Other Items in php function

function causing slow load time

Related Search Terms

php function single 1

php function limit 1

php function difference 1

php function mysql 1

php function code 1

php function Record 1

php function Really 1

php function MySQL 2

php function results 2

php function Other 1

php function select 1

php function here 2

php function n f 1

php function seconds 2

php function php function 2

php function test 1

php function with 1

php function pages 1

php function this 2

php function Single 2

php function slow load time 3

php function ending 1

php function that 2

php function where 1

php function Added 2

php function about 1

php function think 1

php function Where 1

php function record 2

php function make 1

php function another 1

php function Another 1

php function using 6

php function Using 7

php function after 4

php function Times 5

php function generate 2

php function full 3

php function sql 4

php function real 2

php function return 3

php function the 3

php function just 2

php function according 2

php function large 3

php function more 2

php function Correct 1

php function when 2

php function Generate 3

php function times 2

php function normal 2

php function slow 7

php function time 11

php function php 4

php function function 8

php function string 1

php function Sql 2

php function Function 6

php function page 2

Welcome

This is my test area for webdev. I keep a collection of code here, mostly for my reference. Also if i find a good link, i usually add it here and then forget about it. more...