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
