search entire gallery setting ?

[spikeweb]

I checked the forum but did not find an answer. Is there a way to prevent users to search the entire gallery ?

I actually have a gallery with 10000+ images and from time to time, the web server has to handle a long request. The last one is :

Code: [Select]

Query_time: 381
Lock_time: 0
Rows_sent: 10626
Rows_examined: 120771768

SELECT
                               COUNT(*) as total
                       FROM (forum1_gallery_pic as p, forum1_gallery_comment as com)

               LEFT JOIN forum1_members AS m  ON (m.ID_MEMBER = p.ID_MEMBER)
               LEFT JOIN forum1_gallery_usersettings AS s ON (s.ID_MEMBER = m.ID_MEMBER)
               LEFT JOIN forum1_gallery_log_mark_view AS v ON (p.ID_PICTURE = v.ID_PICTURE AND v.ID_MEMBER = 25659 AND v.user_id_cat = p.USER_ID_CAT)
                                       WHERE ((s.private =0 || s.private IS NULL ) AND (s.password = '' || s.password IS NULL ) AND p.USER_ID_CAT !=0 AND p.a
pproved =1) || (p.approved =1 AND p.USER_ID_CAT =0)   AND com.ID_PICTURE = p.ID_PICTURE GROUP BY p.ID_PICTURE;
I wonder how to prevent a guest user/registered user to start search a search.

[SMFHacks]

That query from above is not from search but from the "recentcomments" index display box on the gallery index

If you can do a quick test for me see how long this one takes

Code: [Select]

SELECT
                               COUNT(*) as total
                       FROM (forum1_gallery_pic as p, forum1_gallery_comment as com)

               LEFT JOIN forum1_members AS m  ON (m.ID_MEMBER = p.ID_MEMBER)
               LEFT JOIN forum1_gallery_usersettings AS s ON (s.ID_MEMBER = m.ID_MEMBER)
               LEFT JOIN forum1_gallery_log_mark_view AS v ON (p.ID_PICTURE = v.ID_PICTURE AND v.ID_MEMBER = 25659 AND v.user_id_cat = p.USER_ID_CAT)
                                       WHERE com.ID_PICTURE = p.ID_PICTURE AND ((s.private =0 || s.private IS NULL ) AND (s.password = '' || s.password IS NULL ) AND p.USER_ID_CAT !=0 AND p.a
pproved =1) || (p.approved =1 AND p.USER_ID_CAT =0)   GROUP BY p.ID_PICTURE;

If you need to code to disable the search let me know along with the SMF version used

[spikeweb]

I just ran the query from phpMyAdmin as the previous one was read in the server log :

SELECT COUNT( * ) AS total
FROM (
forum1_gallery_pic AS p, forum1_gallery_comment AS com
)
LEFT JOIN forum1_members AS m ON ( m.ID_MEMBER = p.ID_MEMBER )
LEFT JOIN forum1_gallery_usersettings AS s ON ( s.ID_MEMBER = m.ID_MEMBER )
LEFT JOIN forum1_gallery_log_mark_view AS v ON ( p.ID_PICTURE = v.ID_PICTURE
AND v.ID_MEMBER =25659
AND v.user_id_cat = p.USER_ID_CAT )
WHERE com.ID_PICTURE = p.ID_PICTURE
AND (
(
s.private =0 || s.private IS NULL
)
AND (
s.password = '' || s.password IS NULL
)
AND p.USER_ID_CAT !=0
AND p.approved =1
) || ( p.approved =1
AND p.USER_ID_CAT =0 )
GROUP BY p.ID_PICTURE
LIMIT 0 , 30


The answer is : Affichage des lignes 0 - 29 (1 620 total, Traitement en 9.3797 sec.)

in english : display for lines 0 - 29 (1 620 in total, execution time 9.3797 sec.)

did it help ??

Gallery version is 3.0.22

[spikeweb]

oopppss, just realized that phpMyAdmin allows only 30 results to be displayed.

I can ask my server admin to run the full query ...

[SMFHacks]

What SMF Version are you using going to try something

[spikeweb]

SMF is 1.1.14

[SMFHacks]

It was actually the listall feature for the recent comments block.

Made a couple changes copy this file to your sources folder and let me know if it helps

[spikeweb]

Here is the result of the query as requested :

# Query_time: 29  Lock_time: 0  Rows_sent: 1611  Rows_examined: 23626208

Will check your file and let you know ...