von anzido GmbH
Gesendet: Donnerstag, 28. April 2011 09:16
An: dev-general@lists.oxidforge.org
Betreff: Re: [oxid-dev-general] oxseo fullscan [T-6VJH77ICB7-35]
And some from me:
Shop 1:
Field_name Min_value Max_value Min_length Max_length
Empties_or_zeros
Nachricht-
Von: dev-general-boun...@lists.oxidforge.org
[mailto:dev-general-boun...@lists.oxidforge.org] Im Auftrag von Tobias Merkl
Gesendet: Donnerstag, 28. April 2011 15:55
An: dev-general@lists.oxidforge.org
Betreff: Re: [oxid-dev-general] oxseo fullscan
count(*)avg(length(oxstdurl
Betreff: Re: [oxid-dev-general] oxseo fullscan
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
081
Mobil:0176 - 8325 1488
Email: i...@anzido.com
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
An:
Betreff: Re: [
-general-boun...@lists.oxidforge.org
[mailto:dev-general-boun...@lists.oxidforge.org] On Behalf Of Sarunas
Valaskevicius
Sent: Wednesday, April 27, 2011 1:06 PM
To: dev-general@lists.oxidforge.org
Subject: Re: [oxid-dev-general] oxseo fullscan
Hi,
we are currently fixing this issue,
https
:
An:
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_
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=0564e85caa72a8e
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.
Pl
tp://www.anzido.com ( http://www.anzido.com/ )
USt-ID: DE257982972
Geschäftsführung: Andreas Ziethen
Amtsgericht Dortmund HRB 20883
-Ursprüngliche Daten-
Datum: 26.04.2011 15:30:11
Von: Tobias Merkl
An: dev-general@lists.oxidforge.org
Betreff: [oxid-dev-general] oxseo fullscan
Vorgang: T-6VJH
Hi Tobias, I think this would be a good idea.
This table - in the past - produced real long running
queries at our customers shops especially when using
variants.
Uwe
SD Solutions
Lange Zeile 27
85435 Erding
Tel.: +498122903791
Fax.: +498122903792
eMail: i...@sdsolutions.de
Web: www.sdsolutions.de
Hey community,
does anybody have an idea, why the oxseo-table doesn´t have an index?
I think it would be useful, to change the oxstdurl to an varchar-type and
impose this column with an index?
Kindest regards
Tobias
*
shoptimax GmbH
Guntherstraße 45a
11 matches
Mail list logo
