why there are so many record of search keywords?

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

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing: Jan 19 2025 00:25:32
Script start
Timing: Jan 19 2025 00:25:32
Module start 'layout'
Timing: Jan 19 2025 00:25:32
Module start 'content'
Timing: Jan 19 2025 00:25:33
Module end 'content'
Timing: Jan 19 2025 00:25:33
Script end

Main resources:

Total runtime0.8075 sec
Peak memory usage4,096.0000 KB
Database Queries62

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0066 588.0391152.6406
Module start 'layout' 0.00660.0045 740.679739.4766
Module start 'content' 0.01110.7951 780.1563571.8203
Module end 'content' 0.80630.0012 1,351.976612.1250
Script end 0.8075  1,364.1016 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00340.4239160.0002
Check MTime0.00150.1859160.0001
Mysql Total
Database connection0.00070.089210.0007
Mysqli_queries0.749292.7756620.0121
Looping result0.00060.0774600.0000
Template Total0.769495.320.3847
Template load0.00220.268120.0011
Template processing0.767295.011320.3836
Template load and register function0.00030.037810.0003
states
state_id_array0.00100.125410.0010
state_identifier_array0.00130.160820.0006
Override
Cache load0.00190.2405200.0001
Sytem overhead
Fetch class attribute can translate value0.00070.083130.0002
Fetch class attribute name0.00120.150050.0002
XML
Image XML parsing0.00530.652730.0018
class_abstraction
Instantiating content class attribute0.00000.001650.0000
General
dbfile0.00510.6261160.0003
String conversion0.00000.001340.0000
Note: percentages do not add up to 100% because some accumulators overlap

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
1print_pagelayout.tpl<No override>extension/community/design/community/templates/print_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