mauricecano
829 days ago in 
Tags: dolphin
Reactions: 6 comments •2 points•0 reports 

Sorry Alex

I do want to apologize for my ignorance in this post on what was going on with my sql. I was given erroneous advice from my host and after further research identified the issue. I want to apologize to boonex and Alex for this post.

Plus

Comment•Report

Plussed by

See All ›

Comments

Threaded

Please login to post a comment.

deano92964•829 days ago

I am not sure if you can do that in all areas of dolphin. But perhaps there is something your not aware of.

SELECT `ID` FROM `Profiles` WHERE `ID` = 10 LIMIT 1

That will return only the ID from the database where ID = 10. If dolphin needs any of the other profile fields other than the ID then that query will not be enough.

Permalink•Reply•Plus•0 pluses

mauricecano•829 days ago•in reply to deano92964

I didn't mean to simply every query by just ID, it was an example. The expressions can be rewritten to only columns needed. As an other example, I highly doubt accessdenied.php needs all other 51 default columns of data to find out if the person can view a page. A main issue is that they're calling to the database for every check, there isn't any sort of cache info used so on the home page each block makes its own call to the database, lots of it duplicating queries from other modules.

Permalink•Reply•Plus•0 pluses

AlexT•829 days ago

You understanding of SQL is wrong ! If search field is indexed then MySQL do not examine rows at all, it get it directly, because it is indexed.

"SELECT *" is used in places where most of the fields are user or may be used - also it is not related to the query execution speed.

Also profiles are cached and once cached no access to database is performed to get particular profile info.

Permalink•Reply•Plus•0 pluses

mauricecano•829 days ago

Thanks for the reply Alex but we received a report back from our host stating that the program is continuously going back to the database, especially the profile table. Further, the databases are not set to index or cache. We asked if this was our setup and they examined the files and said this is a result from the dolphin programming.

Permalink•Reply•Plus•0 pluses

Zarcon•829 days ago

Mauricecano, I wonder if he is saying that if you enable caching for you site (HTML, images, CSS, and JS) this would reduce the SQL queries to the database. Queries would only be done if the information has been changed. So either way, the site would need to "periodically" contact the database to make sure everything matched, but should on every single load.

Not sure if I have that right or not.

Permalink•Reply•Plus•0 pluses

AlexT•827 days ago

If you have problems with Dolphin speed I suggest you to use "Profiler" module to find bottlenecks.

Permalink•Reply•Plus•0 pluses