Member Avatar for Arjun_Sarankulu

I have developed the html Frame.
Which contain two php pages
First show the data in the table which is comming from database
and refresh after 30sec
and click on the tr it shows the data in the second frame as in graph(candle chart).

Everything is working fine.
But Problem is everytime it connect to database.
Is there any alternative to this as i dont want to hit server everytime.
This is the Requirement

  • 2 Contributors
  • 3 Replies
  • 84 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by pritaeas
Member Avatar for pritaeas

Is the data different after 30 secs? If not, cache the sql result. If it is, then there is no alternative. How will you retrieve data without connecting?

Member Avatar for Arjun_Sarankulu

Thanks pritaeas,

Actually we are showing the online data
Everytime connecting to database will impact the server.

Member Avatar for pritaeas

So what ? It's made for just that...

If the queries are often the same, use caching.

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.