function causing slow load time [ php function ] - KruXoR

php function

function causing slow load time

Posted in php function

5856

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

5856

2:46 am, April 13, 2023

View Statistics

This Week

160

This Month

540

This Year

3089

No Items Found.

Add Comment

Other Items in php function

function causing slow load time

Related Search Terms

php function Generate 44

php function mysql 60

php function generate 53

php function Sites 42

php function normal 51

php function Times 57

php function According 43

php function according 47

php function single 46

php function that 49

php function slow 46

php function when 50

php function Mysql 55

php function return 54

php function really 44

php function seconds 52

php function correct 54

php function difference 46

php function running 51

php function Using 45

php function time 48

php function just 64

php function Another 51

php function results 53

php function sites 45

php function added 42

php function times 52

php function full 54

php function pages 46

php function Single 47

php function some 50

php function real 51

php function MySQL 48

php function Added 49

php function make 42

php function think 47

php function Other 50

php function false 54

php function about 47

php function where 46

php function function 50

php function select 66

php function name 51

php function result 53

php function Where 46

php function record 53

php function Correct 54

php function with 51

php function more 66

php function Record 50

php function test 55

php function Really 75

php function the 54

php function another 50

php function after 52

php function large 62

php function limit 57

php function page 62

php function from 57

php function using 60

php function ending 60

php function here 48

php function code 40

php function other 56

php function Function 51

php function sql 60

php function php function 66

php function this 68

php function php 64

php function binary 53

php function slow load time 48

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