And some from me:
Shop 1:
--------
Field_name Min_value Max_value Min_length Max_length
Empties_or_zeros Nulls Avg_value_or_avg_length Std
Optimal_fieldtype
live_babymarkt.oxseo.OXSTDURL
?cl=azsitemap&anid=c341929fd71d24d53e11f1fdf99c60a3
index.php?cnid=oxmore&cl=alist 17 113 0 0 78.9497
NULL VARCHAR(113) NOT NULL
live_babymarkt.oxseo.OXSEOURL 11/
xKinderwagen-Babytragen/Zwillingswagen-Geschwisterwagen/ABC-DESIGN-Tragewanne-zum-Zoom-Orange-black-Kollektion-2010.html
2 191 0 0 83.1851 NULL VARCHAR(191)
NOT NULL
count(*)
287345
count(*) avg(length(oxstdurl)) max(length(oxstdurl))
avg(length(oxseourl)) max(length(oxseourl))
287345 78.9497 113 83.1851 191
Shop 2:
-------
Field_name Min_value Max_value Min_length Max_length
Empties_or_zeros Nulls Avg_value_or_avg_length Std
Optimal_fieldtype
usrdb_worhppxo2.oxseo.OXSTDURL
/Zuckerwaren/Brausepulver-Bonbons/Ahoj-Brause/&...
index.php?cnid=oxmore&cl=alist 17 172 0 0 89.4872
NULL VARCHAR(172) NOT NULL
usrdb_worhppxo2.oxseo.OXSEOURL 1-Alles-fuer-die-Schultuete.html
Zuckerwaren/Zuckerwatte-im-Becher.html 2 135 0 0 53.6110
NULL VARCHAR(135) NOT NULL
count(*)
66083
count(*) avg(length(oxstdurl)) max(length(oxstdurl))
avg(length(oxseourl)) max(length(oxseourl))
66083 89.4873 172 53.6112 135
Beste Grüße aus Dortmund!
Andreas Ziethen | Geschäftsführung
--
anzido GmbH
Kirchhörder Str. 12
44229 Dortmund
Tel.: 0231 - 60 71 079
Fax.: 0231 - 60 71 081
Mobil:0176 - 8325 1488
Email: [email protected]
Web: http://www.anzido.com ( http://www.anzido.com/ )
USt-ID: DE257982972
Geschäftsführung: Andreas Ziethen
Amtsgericht Dortmund HRB 20883
-----Ursprüngliche Daten-----
Datum: 27.04.2011 13:06:27
Von: arunasValakevicius <[email protected]>
An: <[email protected]>
Betreff: Re: [oxid-dev-general] oxseo fullscan
Vorgang: T-6VJH77ICB7-35
> 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
_______________________________________________
dev-general mailing list
[email protected]
http://dir.gmane.org/gmane.comp.php.oxid.general
