Member Avatar for ricky_flare

Please help me to improve Performance

Hi........

I am a beginner. I have developed website in Php/MySql. But my home page takes some more time to load in some of the browsers

Check this << url snipped to comply with forum policy >>

Can Mysql stored procedures help me? I don't know the concepts of stored procedures. If any buddy in group knows
pl. help me

Its very urgent. Your feedback/suggestions will be highly appreciated.

  • 3 Contributors
  • 2 Replies
  • 238 Views
  • 6 Days Discussion Span
  • Latest Post Latest Post by rus

Dani AI

Generated

Suggested diagnostic sequence for : begin by measuring where time is actually spent instead of guessing. Capturing a full Network waterfall in the browser devtools (disable cache; optionally throttle to 3G) will show whether major delays are in time‑to‑first‑byte (TTFB — server/DB) or during asset transfer/rendering (images, CSS, JS). Slowness limited to particular browsers usually points to front‑end compatibility or blocking scripts rather than database problems.

Front‑end quick wins normally give the largest, fastest improvements. Common actions include compressing and serving properly scaled images, enabling GZIP/deflate on the server, setting far‑future cache headers for static files, minifying/combining CSS and JS, deferring nonessential scripts with async/defer, and lazy‑loading or paginating below‑the‑fold content to reduce the initial payload and number of HTTP requests.

Database and backend work should follow profiling. Enable the slow‑query log and run EXPLAIN on slow statements to find full‑table scans or bad joins. Typical fixes are adding indexes on WHERE/JOIN columns, avoiding SELECT *, returning only needed columns, paginating large results, and caching expensive query results in memory (memcached/Redis) or at the application layer. Stored procedures can reduce client/server roundtrips in some cases, but they do not replace proper indexing and query tuning and are best considered after simpler, measurable fixes.

Operational changes with immediate impact include enabling PHP opcode caching (OPcache), server compression, and using a CDN for static assets. A pragmatic order is: measure → fix heavy assets and blocking JS → profile and tune queries → add caching → consider stored procedures or architectural changes. That sequence keeps changes small and measurable. ’s distinction between performance and SEO is important, and ’s point about limiting initial payload maps to modern techniques like lazy‑loading and pagination.

Recommended Answers

All 2 Replies

Member Avatar for talkfreelance

Are you looking for page performance or search engine optimization?

Member Avatar for rus

The first thing I would suggest is not to load so much info into a page. A good rule of thumb is that your page should be no more than 2X the height of your browser window. This helps limit the amount of data that is being loaded into a page, keeping file size down.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.