function causing slow load time [ php function ] - KruXoR

php function

function causing slow load time

Posted in php function

5519

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

5519

2:46 am, April 13, 2023

View Statistics

This Week

273

This Month

650

This Year

2752

No Items Found.

Add Comment

Other Items in php function

function causing slow load time

Related Search Terms

php function Generate 42

php function mysql 57

php function generate 47

php function Sites 39

php function normal 51

php function Times 53

php function According 41

php function according 47

php function single 45

php function that 45

php function slow 43

php function when 48

php function Mysql 53

php function return 52

php function really 42

php function seconds 49

php function correct 48

php function difference 44

php function running 47

php function Using 41

php function time 44

php function just 62

php function Another 48

php function results 50

php function sites 43

php function added 39

php function times 51

php function full 50

php function pages 43

php function Single 47

php function some 46

php function real 47

php function MySQL 46

php function Added 46

php function make 39

php function think 44

php function Other 47

php function false 50

php function about 46

php function where 44

php function function 47

php function select 63

php function name 49

php function result 50

php function Where 42

php function record 46

php function Correct 52

php function with 48

php function more 64

php function Record 48

php function test 54

php function Really 72

php function the 48

php function another 49

php function after 49

php function large 60

php function limit 53

php function page 61

php function from 54

php function using 57

php function ending 55

php function here 46

php function code 38

php function other 52

php function Function 49

php function sql 56

php function php function 64

php function this 67

php function php 60

php function binary 47

php function slow load time 45

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