php function

function causing slow load time

Posted in php function
5964
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
5964
2:46 am, April 13, 2023

View Statistics
This Week
173
This Month
648
This Year
3197

No Items Found.

Add Comment
Type in a Nick Name here
 
Other Items in php function
function causing slow load time
Related Search Terms
php function Generate 46
php function mysql 60
php function generate 53
php function Sites 43
php function normal 52
php function Times 59
php function According 44
php function according 48
php function single 46
php function that 50
php function slow 48
php function when 52
php function Mysql 57
php function return 55
php function really 44
php function seconds 52
php function correct 55
php function difference 46
php function running 52
php function Using 46
php function time 49
php function just 64
php function Another 52
php function results 55
php function sites 46
php function added 43
php function times 54
php function full 56
php function pages 46
php function Single 47
php function some 51
php function real 53
php function MySQL 49
php function Added 49
php function make 44
php function think 48
php function Other 50
php function false 57
php function about 49
php function where 46
php function function 51
php function select 67
php function name 52
php function result 55
php function Where 46
php function record 56
php function Correct 55
php function with 52
php function more 67
php function Record 51
php function test 57
php function Really 75
php function the 54
php function another 51
php function after 54
php function large 63
php function limit 57
php function page 62
php function from 58
php function using 62
php function ending 60
php function here 50
php function code 41
php function other 57
php function Function 52
php function sql 60
php function php function 67
php function this 72
php function php 65
php function binary 53
php function slow load time 49
Other Categories in Code
alpine js apps c css factorio font awesome images linux quick modals sqlite site bugs site updates slick slider sliders testing windows apps apache api apps asp bat bootstrap bootstrap templates charts cookies core css css filters css grid design elements docker domains emoji fancybox fonts foundation framework gimp git html icons ideas image formatting images javascript javascript functions jquery js linux mac misc modals mysql nginx node php php errors php function php functions php simple html dom pi400 python react regex sections simple_html_dom simplepie php site bugs site documentation slick slider sql sqlite ssh sublime svg svg css templates tools virtual box vscode vue webdev windows windows 11 windows commands wordpress
Search Code
Search Code by entering your search text above.
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...

Subscribe to weekly updates about things i have added to the site or thought interesting during the last week.

You could also follow me on twitter or not... does anyone even use twitter anymore?

If you found something useful or like my work, you can buy me a coffee here. Mmm Coffee. ☕

❤️👩‍💻🎮

🪦 2000 - 16 Oct 2022 - Boots
Random Quote
⠄⠄⣿⣿⣿⣿⠘⡿⢛⣿⣿⣿⣿⣿⣧⢻⣿⣿⠃⠸⣿⣿⣿⠄⠄⠄⠄⠄
⠄⠄⣿⣿⣿⣿⢀⠼⣛⣛⣭⢭⣟⣛⣛⣛⠿⠿⢆⡠⢿⣿⣿⠄⠄⠄⠄⠄
⠄⠄⠸⣿⣿⢣⢶⣟⣿⣖⣿⣷⣻⣮⡿⣽⣿⣻⣖⣶⣤⣭⡉⠄⠄⠄⠄⠄
⠄⠄⠄⢹⠣⣛⣣⣭⣭⣭⣁⡛⠻⢽⣿⣿⣿⣿⢻⣿⣿⣿⣽⡧⡄⠄⠄⠄
⠄⠄⠄⠄⣼⣿⣿⣿⣿⣿⣿⣿⣿⣶⣌⡛⢿⣽⢘⣿⣷⣿⡻⠏⣛⣀⠄⠄
⠄⠄⠄⣼⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣦⠙⡅⣿⠚⣡⣴⣿⣿⣿⡆⠄
⠄⠄⣰⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣷⠄⣱⣾⣿⣿⣿⣿⣿⣿⠄
⠄⢀⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⢸⣿⣿⣿⣿⣿⣿⣿⣿⠄
⠄⣸⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⡿⠣⣿⣿⣿⣿⣿⣿⣿⣿⣿⠄
⠄⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⠿⠛⠑⣿⣮⣝⣛⠿⠿⣿⣿⣿⣿⠄
⢠⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣶⠄⠄⠄⠄⣿⣿⣿⣿⣿⣿⣿⣿⣿⡟⠄

Random CSS Property

<length>

The <length> CSS data type represents a distance value. Lengths can be used in numerous CSS properties, such as width, height, margin, padding, border-width, font-size, and text-shadow.
length#ex css reference