function causing slow load time [ php function ] - KruXoR

php function

function causing slow load time

Posted in php function

6047

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

6047

2:46 am, April 13, 2023

View Statistics

This Week

79

This Month

732

This Year

3281

No Items Found.

Add Comment

Other Items in php function

function causing slow load time

Related Search Terms

php function Generate 47

php function mysql 60

php function generate 54

php function Sites 43

php function normal 52

php function Times 59

php function According 45

php function according 49

php function single 49

php function that 51

php function slow 48

php function when 53

php function Mysql 58

php function return 56

php function really 45

php function seconds 52

php function correct 56

php function difference 46

php function running 53

php function Using 46

php function time 50

php function just 65

php function Another 53

php function results 56

php function sites 46

php function added 44

php function times 54

php function full 56

php function pages 46

php function Single 48

php function some 51

php function real 53

php function MySQL 49

php function Added 51

php function make 45

php function think 49

php function Other 51

php function false 59

php function about 51

php function where 47

php function function 53

php function select 68

php function name 53

php function result 55

php function Where 48

php function record 56

php function Correct 56

php function with 52

php function more 68

php function Record 51

php function test 58

php function Really 77

php function the 55

php function another 52

php function after 54

php function large 64

php function limit 57

php function page 63

php function from 58

php function using 63

php function ending 61

php function here 51

php function code 41

php function other 59

php function Function 52

php function sql 60

php function php function 70

php function this 72

php function php 66

php function binary 53

php function slow load time 50

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