Hello! here are my results:
count(*) avg(length(oxstdurl)) max(length(oxstdurl)) avg(length(oxseourl)) max(length(oxseourl)) 7891 47.3845 72 30.0958 93 Viele Grüße! Alex -----Ursprüngliche Daten----- Datum: 27.04.2011 13:55:59 Von: <[email protected]> An: <[email protected]> Betreff: Re: [oxid-dev-general] oxseo fullscan Vorgang: T-3KTAD7XD7K-55 > Dear all, > here are the results: > > 1) SELECT oxstdurl,oxseourl FROM `oxseo` PROCEDURE ANALYSE(1,1); > Field_name |Min_value |Max_value |Min_length |Max_length > |Empties_or_zeros |Nulls |Avg_value_or_avg_length |Std > |Optimal_fieldtype > sindoshop_prod.oxseo.OXSTDURL > |?cl=rss&fnc=catarts&cat=0564e85caa72a8ed10... > |index.php?mi=support&cl=news |17 |242 |0 |0 |102.1432 |NULL > |VARCHAR(242) NOT NULL > sindoshop_prod.oxseo.OXSEOURL |-oxid-39/ |zh/rss/IGBT/MOSFET/ |1 |93 |0 > |0 |54.2201 |NULL |VARCHAR(93) NOT NULL > > 2) SELECT count(*) FROM oxseo; > 35438 > > > Kind regards, > Martin Kirchmayer > > -- > Martin Kirchmayer (Dipl.-Ing.) > IT-Projektleiter eCommerce > Tel.: +49 911 30919 140 > Fax: +49 911 30919 77 140 > [email protected] > > SindoPower GmbH > Vershofenstr. 3 Postfach 820251 > 90431 Nürnberg, Germany 90253 Nürnberg > Amtsgericht Nürnberg HRB 19111 > > Geschäftsführer: > - Dr. Walter Demmelhuber > - Rudhard Riemer > > > >>> Šar*nas Valaškevi*ius<[email protected]> > 27.04.2011 13:06 >>> > Hi, > > we are currently fixing this issue, > https://bugs.oxid-esales.com/view.php?id=2740 . > > The solution to change oxstdurl and oxseourl fields to varchar(2048) > currently sounds the best. > > Also, to select good indexing length we would need feedback about > usual > lengths of these data in real shops. > Please help us by gathering some statistical data about these data in > your shop database. > Could you please run the following query and send us the results? > (just > post the results here in the dev general) > > SELECT oxstdurl,oxseourl FROM `oxseo` PROCEDURE ANALYSE(1,1); > > together with data count returned by > > SELECT count(*) FROM oxseo; > > if it wouldn't work (e.g. some mysql clients automatically append > limit > clause after procedure), you could also use simple sql such as: > > select count(*), avg(length(oxstdurl)), max(length(oxstdurl)), > avg(length(oxseourl)), max(length(oxseourl)) from oxseo; > > > Note, that on huge databases these selects will increase load. > Especially if your database is already under heavy load, > it would be best to run it on a separate db clone or at least on more > idle hours. > > > Regards, > Sarunas > > > On Tue, 2011-04-26 at 16:01 +0200, anzido GmbH wrote: > > Hi, > > > > > > > I think it would be useful, to change the oxstdurl to an > varchar-type and impose this column with an index? > > > > It's not only "useful" - it's absolutely essential if you have a big > shop with much traffic! > > Also you should take care that searching for seo urls is done only if > the std url CAN HAVE any seo url. For example if the std url looks like: > index.php?force_sid= .... OR index.php?stoken=.... OR index.php?.... > cl=search and so on - there is NO seo url and searching for it is > absolutely needless and a waste of ressources. > > > > On one of our bigger projects we reduced the total number of sql > queries by nearly 20%! > > > > > > Beste Grüße aus Dortmund! > > Andreas Ziethen | Geschäftsführung > > > > > _______________________________________________ > dev-general mailing list > [email protected] > http://dir.gmane.org/gmane.comp.php.oxid.general > > > ______________________________________________________________________ > This email has been scanned by the MessageLabs Email Security System. > ______________________________________________________________________ > _______________________________________________ > dev-general mailing list > [email protected] > http://dir.gmane.org/gmane.comp.php.oxid.general _______________________________________________ dev-general mailing list [email protected] http://dir.gmane.org/gmane.comp.php.oxid.general
