Jump to content
www.HDsports.at

Many Database queries

Recommended Posts

www.HDsports.at

hey,

is it normal that one jreviews module ( JReviews Reviews Module) produces 25 databse queries?


i tested it with debug manager

when i activated this module i had 100 database-queries. many from them are jreviews

 

10 × SELECT Criteria.id AS `Criteria.criteria_id`, Criteria.title AS `Criteria.title`, Criteria.groupid AS `Criteria.group_id`, Criteria.state AS `Criteria.state`, Criteria.search AS `Criteria.search`, Criteria.required AS `Criteria.required`, Criteria.config AS `ListingType.config`
  FROM ngie_jreviews_criteria AS Criteria
7 × SELECT                     groupid                    FROM ngie_jreviews_groups

3 × SELECT CriteriaRating.criteria_id AS `CriteriaRating.criteria_id`, CriteriaRating.title AS `CriteriaRating.title`, CriteriaRating.required AS `CriteriaRating.required`, CriteriaRating.weight AS `CriteriaRating.weight`, CriteriaRating.description AS `CriteriaRating.description`, CriteriaRating.listing_type_id AS `CriteriaRating.listing_type_id`, CriteriaRating.ordering AS `CriteriaRating.ordering`, ListingType.state AS `CriteriaRating.listing_type_state`
  FROM ngie_jreviews_criteria_ratings AS CriteriaRating
  LEFT JOIN ngie_jreviews_criteria AS ListingType
  ON ListingType.id = CriteriaRating.listing_type_id

2 × SELECT Field.fieldid AS `Field.field_id`, Field.groupid AS `Field.group_id`, Field.name AS `Field.name`, Field.title AS `Field.title`, Field.showtitle AS `Field.showTitle`, Field.description AS `Field.description`, Field.required AS `Field.required`, Field.type AS `Field.type`, Field.location AS `Field.location`, Field.options AS `Field.params`, Field.contentview AS `Field.contentView`, Field.listview AS `Field.listView`, Field.compareview AS `Field.compareView`, Field.listsort AS `Field.listSort`, Field.search AS `Field.search`, Field.access AS `Field.access`, Field.access_view AS `Field.accessView`, Field.published As `Field.published`, Field.ordering AS `Field.ordering`, `
  Group`.groupid AS `
  Group.group_id`, `
  Group`.title AS `
  Group.title`, `
  Group`.name AS `
  Group.name`, `
  Group`.showtitle AS `
  Group.showTitle`, `
  Group`.ordering AS `
  Group.ordering`
  FROM ngie_jreviews_fields AS Field
  LEFT JOIN ngie_jreviews_groups AS `
  Group`
  ON `
  Group`.groupid = Field.groupid
 × SELECT                         *                     
  FROM                         ngie_jreviews_fieldoptions

2 × SELECT media.media_id, media.media_type, media.media_function, media.likes_rank, media.likes_up, media.likes_total, media.created, media.main_media, media.listing_id, media.review_id, media.user_id, media.filename, media.file_extension, media.rel_path, media.title, media.description, media.media_info, media.metadata, media.embed, media.published, media.approved, media.access, media.views, media.filesize, media.extension
  FROM ngie_jreviews_media AS media

and some more with 1x


when i deactivate this module i have only 75 db queries


i am not really know if thats normal, but i think thats not good for performance of web site...

Edited by www.HDsports.at

Share this post


Link to post
Alejandro

This section is only visible with a valid subscription. If you have a valid subscription, please login.

Share this post


Link to post
www.HDsports.at

This section is only visible with a valid subscription. If you have a valid subscription, please login.

Edited by www.HDsports.at

Share this post


Link to post
Alejandro

This section is only visible with a valid subscription. If you have a valid subscription, please login.

Share this post


Link to post
www.HDsports.at

This section is only visible with a valid subscription. If you have a valid subscription, please login.

Edited by www.HDsports.at

Share this post


Link to post
Alejandro

This section is only visible with a valid subscription. If you have a valid subscription, please login.

Share this post


Link to post
www.HDsports.at

This section is only visible with a valid subscription. If you have a valid subscription, please login.

Edited by www.HDsports.at

Share this post


Link to post
Alejandro

This section is only visible with a valid subscription. If you have a valid subscription, please login.

Share this post


Link to post
www.HDsports.at

This section is only visible with a valid subscription. If you have a valid subscription, please login.

Edited by www.HDsports.at

Share this post


Link to post
Alejandro

This section is only visible with a valid subscription. If you have a valid subscription, please login.

Share this post


Link to post

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Please refer to our Privacy Policy.