function causing slow load time [ php function ] - KruXoR

php function

function causing slow load time

Posted in php function

5126

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

5126

2:46 am, April 13, 2023

View Statistics

This Week

124

This Month

671

This Year

2358

No Items Found.

Add Comment

Other Items in php function

function causing slow load time

Related Search Terms

php function Generate 37

php function mysql 53

php function generate 42

php function Sites 35

php function normal 44

php function Times 49

php function According 38

php function according 44

php function single 41

php function that 41

php function slow 39

php function when 44

php function Mysql 47

php function return 45

php function really 39

php function seconds 45

php function correct 43

php function difference 39

php function running 43

php function Using 37

php function time 40

php function just 56

php function Another 45

php function results 45

php function sites 40

php function added 36

php function times 47

php function full 46

php function pages 38

php function Single 43

php function some 44

php function real 43

php function MySQL 40

php function Added 41

php function make 36

php function think 41

php function Other 44

php function false 46

php function about 41

php function where 39

php function function 45

php function select 59

php function name 45

php function result 47

php function Where 35

php function record 43

php function Correct 49

php function with 45

php function more 56

php function Record 46

php function test 49

php function Really 67

php function the 44

php function another 45

php function after 45

php function large 55

php function limit 48

php function page 57

php function from 48

php function using 54

php function ending 51

php function here 43

php function code 35

php function other 48

php function Function 43

php function sql 52

php function php function 58

php function this 61

php function php 55

php function binary 43

php function slow load time 42

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