Forums / General / why there are so many record of search keywords?

why there are so many record of search keywords?

« 
Previous topic
|
General
|
Next topic
 »
Author Message

kevin wei

Tuesday 08 February 2005 11:54:18 pm

i built a site with ez3.5, and added 2000 nodes, last day when i backup database, i found the size of backup.sql was 14M,
its so huge, and i found there 100,000 records is about ez search keyword?
i want to know if i add 800,000 node, how many database it spared, and how can i reduce search recode produced by ez.
because i do no need too much search, even i can stop search.
so many search recode are not suitable for individual using on ISP's host.
do there have any suggestion concerning this teerible searching keyword?
thanks!

Tom Couwberghs

Wednesday 09 February 2005 12:23:26 am

This is because eZ Publish indexes every contentobjectattribute that is set to "searchable". If you don't want this to happen, or only want to index certain attributes, disable the is_searchable attribute in the respective 'class edit'

HTH

Tom

kevin wei

Saturday 12 February 2005 7:09:22 pm

yes, i had disable the option of some fileds ' "searchable", but now how can i delete those already generated search words?
thanx!

Gabriel Ambuehl

Sunday 13 February 2005 1:12:23 am

That's explained in the docs, "regeneration of index" or some such.

Visit http://triligon.org

eZ debug

Timing: Jan 18 2025 21:17:35
Script start
Timing: Jan 18 2025 21:17:35
Module start 'content'
Timing: Jan 18 2025 21:17:36
Module end 'content'
Timing: Jan 18 2025 21:17:37
Script end

Main resources:

Total runtime1.3124 sec
Peak memory usage4,096.0000 KB
Database Queries199

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0060 587.8359180.8203
Module start 'content' 0.00601.2040 768.6563576.9141
Module end 'content' 1.21010.1023 1,345.5703333.3750
Script end 1.3124  1,678.9453 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00430.3239210.0002
Check MTime0.00160.1242210.0001
Mysql Total
Database connection0.00060.049410.0006
Mysqli_queries1.246394.95931990.0063
Looping result0.00170.13121970.0000
Template Total1.280697.620.6403
Template load0.00230.178820.0012
Template processing1.278397.395820.6391
Template load and register function0.00010.010510.0001
states
state_id_array0.00150.115210.0015
state_identifier_array0.00250.192620.0013
Override
Cache load0.00200.1499200.0001
Sytem overhead
Fetch class attribute can translate value0.00100.073640.0002
Fetch class attribute name0.00090.068650.0002
XML
Image XML parsing0.00100.073540.0002
class_abstraction
Instantiating content class attribute0.00000.000850.0000
General
dbfile0.00400.3020270.0001
String conversion0.00000.000730.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
4content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
2content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
4content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
1content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 13
 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs