function causing slow load time [ php function ] - KruXoR

php function

function causing slow load time

Posted in php function

4167

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

4167

2:46 am, April 13, 2023

View Statistics

This Week

212

This Month

524

This Year

1399

No Items Found.

Add Comment

Other Items in php function

function causing slow load time

Related Search Terms

php function Generate 31

php function mysql 38

php function generate 38

php function Sites 30

php function normal 38

php function Times 43

php function According 33

php function according 38

php function single 34

php function that 34

php function slow 33

php function when 40

php function Mysql 34

php function return 34

php function really 31

php function seconds 38

php function correct 33

php function difference 35

php function running 38

php function Using 30

php function time 35

php function just 31

php function Another 36

php function results 39

php function sites 35

php function added 30

php function times 39

php function full 41

php function pages 30

php function Single 35

php function some 36

php function real 32

php function MySQL 34

php function Added 32

php function make 30

php function think 35

php function Other 38

php function false 37

php function about 34

php function where 36

php function function 34

php function select 39

php function name 39

php function result 41

php function Where 30

php function record 35

php function Correct 39

php function with 36

php function more 39

php function Record 38

php function test 41

php function Really 34

php function the 38

php function another 37

php function after 37

php function large 40

php function limit 39

php function page 34

php function from 38

php function using 42

php function ending 43

php function here 37

php function code 30

php function other 43

php function Function 36

php function sql 39

php function php function 49

php function this 49

php function php 42

php function binary 36

php function slow load time 34

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...