function causing slow load time [ php function ] - KruXoR

php function

function causing slow load time

Posted in php function

1221

2:46 am, April 13, 2023

0 0 0

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

1221

2:46 am, April 13, 2023

View Statistics

This Week

110

This Month

483

This Year

2053

No Items Found.

Add Comment

Other Items in php function

function causing slow load time

Related Search Terms

php function thin 9

php function string 10

php function Sql 9

php function table 11

php function but 20

php function all 8

php function n f 10

php function PHP 14

php function Generate 54

php function mysql 76

php function generate 64

php function Sites 49

php function normal 65

php function Times 71

php function According 59

php function according 59

php function single 68

php function that 65

php function slow 57

php function when 64

php function Mysql 69

php function return 76

php function really 58

php function seconds 65

php function correct 80

php function difference 67

php function running 63

php function Using 56

php function time 64

php function just 78

php function Another 64

php function results 71

php function sites 55

php function added 60

php function times 68

php function full 69

php function pages 62

php function Single 59

php function some 65

php function real 63

php function MySQL 61

php function Added 63

php function make 54

php function think 55

php function Other 62

php function false 70

php function about 60

php function where 58

php function function 68

php function select 85

php function name 68

php function result 68

php function Where 63

php function record 64

php function Correct 75

php function with 65

php function more 81

php function Record 58

php function test 71

php function Really 86

php function the 66

php function another 67

php function after 69

php function large 74

php function limit 71

php function page 76

php function from 77

php function using 77

php function ending 74

php function here 67

php function code 55

php function other 71

php function Function 72

php function sql 79

php function php function 87

php function this 87

php function php 90

php function binary 63

php function slow load time 58

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