New Full Text Indexing

For general questions and discussions specific to the AbleCommerce GOLD ASP.Net shopping cart software.
Post Reply
dc8johnson
Lieutenant Commander (LCDR)
Lieutenant Commander (LCDR)
Posts: 87
Joined: Fri Nov 20, 2009 8:46 am

New Full Text Indexing

Post by dc8johnson » Wed Sep 26, 2012 4:50 pm

How long should the new Full Text Indexing take? We've converted a 7.0.7 store to GOLD with
  • 95,000 products (about 50,000 are currently visible)
    1,500 categories
    56,000 orders
    26,000 users
After about 30 minutes after we converted the database we could start doing searches on the site. Searches are pretty fast, but according to the admin page, it says the indexing is still running (over 1,800 minutes).

Any guidance on this?

Thanks,
David Johnson

User avatar
Shopping Cart Admin
AbleCommerce Admin
AbleCommerce Admin
Posts: 3055
Joined: Mon Dec 01, 2003 8:41 pm
Location: Vancouver, WA
Contact:

Re: New Full Text Indexing

Post by Shopping Cart Admin » Wed Sep 26, 2012 5:41 pm

Hello David,

This is going to vary greatly by the servers performance and current load. If I'm reading your information in the post correctly it seems about another hour and it would be completed.

1800 products a minute * 27.77 minutes equals your 50k products, so it seems to be giving you correct information.

It's a new feature for me as well, so I'm interested to hear how it goes for you.
Thanks for your support

Shopping Cart Guru
AbleCommerce.com
Follow us on Facebook

User avatar
david-ebt
Captain (CAPT)
Captain (CAPT)
Posts: 253
Joined: Fri Dec 31, 2010 10:12 am

Re: New Full Text Indexing

Post by david-ebt » Wed Sep 26, 2012 5:46 pm

OK, I'll let you know how it looks tomorrow.

Thanks!
David
http://www.ecombuildertoday.com
Enhanced Reporting for AbleCommerce
Image

User avatar
Logan Rhodehamel
Developer
Developer
Posts: 4116
Joined: Wed Dec 10, 2003 5:26 pm

Re: New Full Text Indexing

Post by Logan Rhodehamel » Fri Sep 28, 2012 1:13 pm

Wait... it says indexing is still running after 1800 minuets?
Cheers,
Logan
Image.com

If I do not respond to an unsolicited private message, it's not because I'm ignoring you. It's because the answer to your question is valuable to others. Try the new topic button.

dc8johnson
Lieutenant Commander (LCDR)
Lieutenant Commander (LCDR)
Posts: 87
Joined: Fri Nov 20, 2009 8:46 am

Re: New Full Text Indexing

Post by dc8johnson » Fri Sep 28, 2012 5:03 pm

Actually, it's still going. The searches seem to be working - although we're having some odd results we're trying to work with.
David Johnson

User avatar
Logan Rhodehamel
Developer
Developer
Posts: 4116
Joined: Wed Dec 10, 2003 5:26 pm

Re: New Full Text Indexing

Post by Logan Rhodehamel » Sat Sep 29, 2012 11:17 am

No I don't believe that is correct. It somehow didn't detect that the indexing completed. When I did tests prior to release I indexed 1 million products and it only took a few hours.

If I were you, I would click to abort. Then this evening go to that page and request a reindex.
Cheers,
Logan
Image.com

If I do not respond to an unsolicited private message, it's not because I'm ignoring you. It's because the answer to your question is valuable to others. Try the new topic button.

Post Reply