php function

function causing slow load time

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

View Statistics
This Week
156
This Month
536
This Year
3085

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 44
php function mysql 60
php function generate 53
php function Sites 42
php function normal 51
php function Times 57
php function According 43
php function according 47
php function single 46
php function that 49
php function slow 45
php function when 50
php function Mysql 54
php function return 54
php function really 44
php function seconds 52
php function correct 53
php function difference 46
php function running 51
php function Using 45
php function time 48
php function just 64
php function Another 51
php function results 53
php function sites 45
php function added 42
php function times 52
php function full 54
php function pages 46
php function Single 47
php function some 50
php function real 51
php function MySQL 48
php function Added 49
php function make 42
php function think 47
php function Other 50
php function false 54
php function about 47
php function where 46
php function function 50
php function select 66
php function name 51
php function result 53
php function Where 46
php function record 53
php function Correct 54
php function with 51
php function more 66
php function Record 50
php function test 55
php function Really 75
php function the 54
php function another 50
php function after 52
php function large 62
php function limit 57
php function page 62
php function from 57
php function using 60
php function ending 60
php function here 48
php function code 40
php function other 55
php function Function 51
php function sql 60
php function php function 66
php function this 68
php function php 64
php function binary 53
php function slow load time 48
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#vmin css reference