I just updated the script to work in php8+. All I really want to know is two things: 1. How fast the index page loaded 2. How fast an ad (in the slider) loaded when you clicked on it. https://qwikad.com Thanks!!
For the main index load - noticeable lag connecting but fast after that. No lag for the ads. chrome, macos, wifi from fibre
Hello @qwikad.com, Great job on updating your script to be compatible with PHP8+! Regarding your questions about site performance: Index Page Load Time: The load time can vary based on several factors including server speed, the amount of content on the page, and user connection speed. Tools like Google PageSpeed Insights or GTmetrix can provide a detailed analysis of what might be slowing down your page. Ad Load Speed in the Slider: This is often influenced by the ad content itself (size of images, any scripts running, etc.) as well as how the slider is implemented. If the slider is not optimized for asynchronous loading, it might delay the ad display. If you're looking for detailed insights on optimizing website speed and performance, especially for dynamic content like ads, I've covered similar topics extensively, focusing on best practices for web performance. While I can’t post links directly here, you can find this guide by searching for "https://getgbwa.in/" with keywords like 'website speed optimization'. It might provide you with some actionable advice that could help improve both your index load time and ad responsiveness. Keep up the great work, and I look forward to seeing how your site progresses!
Thank you. Something that my old script wasn't affected by, but this one is: where the "sql select" codes are may determine how fast the page will load. The higher on a page they are the faster it'll load. Another thing I keep noticing: Firefox and Opera load the site faster than Chrome. I wonder if some js files and the overall page structure is the cause of it.
It depends on what that query is doing but you may be able to cache the results or split it out. Caching probably is out but give this a try. Let's say the SQL query that is slowing things down is the for the slider.... I'd use CSS to create the space and then have a javascript function that uses ajax to load the actual content. There needs to be another script to run the problem query and output json. That way the query is run separately and the page loads with the ads loading moments later.
I'll keep experimenting. As I mentioned, my old script would start loading the pages while executing the queries. PDO/php8+ is funky. There's this weird split second/second delay before every execution. I'll have to accept it as a new norm and find a way to work around it (as you suggested also).
Don't have any real proof, but it looks like this: foreach ($stmt as $row) { ...some content } outperforms this: while ($row = $stmt->fetch()) { ...some content } At least in my case. Any validity to this?