Magento Commerce Advanced search is very slow.

[RFeri]

Hello,

Magento Commerce Advanced search is very slow. (100,000 products, 20
seconds)

Seeking a solution to be 1-2 seconds of search time.

Here is an example, but it will not be developed:
http://www.magentocommerce.com/magento-connect/PremierWeb/extension/922/premierweb-sphinx-enterprise-search

Thank You
Ferenc

[Mathew]

Isnt that where SOLR starts to become very handy?

http://code.google.com/p/magento-solr/

Open source, server level search support. Take a look and see if it can
apply to what you are doing.

Mathew Beane
m...@idealphp.com

[Damian Luszczymak]

Hi Ferenc,

also you can use my solution

http://www.magentocommerce.com/extension/6721/

Damian

2011/8/31 Mathew <aep...@gmail.com>

--
You received this message because you are subscribed to the Google Groups "Magento Development List" group.
To post to this group, send email to magent...@googlegroups.com.
To unsubscribe from this group, send email to magento-devel+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/magento-devel?hl=en.

[Ferenc Reischig]

Hi Damian,

I prefer sphinxsearch,

I tried the demo but it does not work

http://demo02.solrgento.com/catalogsearch/advanced/result/?name=&description=&short_description=&sku=&price[from]=1&price[to]=10000000&tax_class_id[]=0
Fatal error: Call to undefined method Icyapp_Solr_Model_Mysql4_Fulltext_Engine::getAdvancedResultCollection() in /var/www/demo02.solrgento.com/html/app/code/core/Mage/CatalogSearch/Model/Advanced.php on line 270

2011/9/1 Damian Luszczymak <daim...@googlemail.com>

To unsubscribe from this group, send email to magento-deve...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/magento-devel?hl=en.

--
Üdvözlettel:
Reischig Ferenc

Renetonline Kft.
2141 Csömör, Knipfer Tibor u. 10
Tel / Fax: +36 21 202 57 58
Mobil: 0670 457 5678
http://drhauschkakozmetikumok.hu/
http://alfadrogeria.hu/
http://konyvkapu.hu/

[Damian Luszczymak]

Hi Ferenc,

sphinxsearch doesn't make the same ;-)

In the Demo is only the normal search activated, sorry for this.

Damian

2011/9/1 Ferenc Reischig <reis...@gmail.com>

[Boris Gurvich]

Hey,

Can you have 15-30 min for me regarding solr?

Thanks!
Boris.

On Wed, 31 Aug 2011 19:23:32 -0400, Damian Luszczymak
<daim...@googlemail.com> wrote:

> Hi Ferenc,
>
> also you can use my solution
> http://www.magentocommerce.com/extension/6721/
>
>
> Damian
>
> 2011/8/31 Mathew <aep...@gmail.com>
>
>> Isnt that where SOLR starts to become very handy?
>>

>> http://code.google.com/p/**magento-solr/<http://code.google.com/p/magento-solr/>

>>
>> Open source, server level search support. Take a look and see if it can
>> apply to what you are doing.
>>
>> Mathew Beane
>> m...@idealphp.com
>>
>>
>> On 8/31/2011 1:57 AM, RFeri wrote:
>>

<snip>

>> --
>> You received this message because you are subscribed to the Google
>> Groups
>> "Magento Development List" group.

>> To post to this group, send email to magent...@googlegroups.com**.

>> To unsubscribe from this group, send email to

>> magento-devel+unsubscribe@**
>> googlegroups.com <magento-devel%2Bunsu...@googlegroups.com>.
>> For more options, visit this group at http://groups.google.com/**
>> group/magento-devel?hl=en<http://groups.google.com/group/magento-devel?hl=en>
>> .
>>
>>
>

[Unirgy]

Guys, I'm really sorry about this spam, was under impression I'm
sending directly to someone... Won't happen again.

On Feb 21, 11:31 pm, "Boris Gurvich" <uni...@gmail.com> wrote:
> Hey,
>
> Can you have 15-30 min for me regarding solr?
>
> Thanks!
> Boris.
>
> On Wed, 31 Aug 2011 19:23:32 -0400, Damian Luszczymak
>
>
>
>
>
>
>
>
>
> <daim1...@googlemail.com> wrote:
> > Hi Ferenc,
>
> > also you can use my solution
> >http://www.magentocommerce.com/extension/6721/
>
> > Damian
>

> > 2011/8/31 Mathew <aepo...@gmail.com>

>
> >> Isnt that where SOLR starts to become very handy?
>
> >>  http://code.google.com/p/**magento-solr/<http://code.google.com/p/magento-solr/>
>
> >> Open source, server level search support. Take a look and see if it can
> >> apply to what you are doing.
>
> >> Mathew Beane
> >> m...@idealphp.com
>
> >> On 8/31/2011 1:57 AM, RFeri wrote:
>
> <snip>
> >> --
> >> You received this message because you are subscribed to the Google
> >> Groups
> >> "Magento Development List" group.
> >> To post to this group, send email to magent...@googlegroups.com**.
> >> To unsubscribe from this group, send email to
> >> magento-devel+unsubscribe@**
> >> googlegroups.com <magento-devel%2Bunsu...@googlegroups.com>.

> >> For more options, visit this group athttp://groups.google.com/**
> >> group/magento-devel?hl=en<http://groups.google.com/group/magento-devel?hl=en>
> >> .