Asset Manager lags with over 4000 images

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
bemara579
Lieutenant (LT)
Lieutenant (LT)
Posts: 63
Joined: Thu Feb 19, 2009 6:15 pm

Asset Manager lags with over 4000 images

Post by bemara579 » Wed Apr 15, 2009 8:39 pm

I have 4000 products with images in the ~/Assets/ProductImages folder. When I go to the Asset Manager in the Admin panel (Manage->Images and Assets), it does not load up. The ajaz wheel just keeps spinning and spinning. Isn't there a better way to handle large amounts of images?

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: Asset Manager lags with over 4000 images

Post by jmestep » Thu Apr 16, 2009 6:23 am

Some sites have put the images into subfolders based on the first one character in the name of the image. They would upload the images via ftp into those folders then enter the urls into the database. The automatic image matching by sku lookup woudn't work that way, though.
I've been working on moving a site that has 250,000 images in the ProductImages folder and we are going to set it up with the subfolders and do queries to the database to to update the links. When I first started working on the site my ftp program would time out trying to access the folder. Even going in to the new dedicated server via rdp would take 30-45 minutes to open the folder up in explorer.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

bemara579
Lieutenant (LT)
Lieutenant (LT)
Posts: 63
Joined: Thu Feb 19, 2009 6:15 pm

Re: Asset Manager lags with over 4000 images

Post by bemara579 » Mon May 04, 2009 4:26 pm

A quarter million images is a lot of images, but I'm only talking about 4,000. Via RDP, opening the folder is instant, so is FTP.

I think the Asset Manager should incorporate some paging via AJAX (will work in your case too), otherwise it's pretty useless for large clients.

My error logs are loaded with these errors and makes choosing product images undoable for large clients:

5/4/2009 3:38:33 PM Error An error has occured at http://mydomain.com/Admin/Products/Asse ... nager.aspx Request timed out.
5/4/2009 2:48:00 PM Error An error has occured at http://mydomain.com/Admin/Products/Asse ... umbnailUrl Request timed out.
5/4/2009 2:10:35 PM Error An error has occured at http://mydomain.com/Admin/Products/Asse ... umbnailUrl Request timed out.
5/4/2009 2:08:45 PM Error An error has occured at http://mydomain.com/Admin/Products/Asse ... umbnailUrl Request timed out.
5/4/2009 2:06:56 PM Error An error has occured at http://mydomain.com/Admin/Products/Asse ... umbnailUrl Request timed out.

rpb3
Lieutenant (LT)
Lieutenant (LT)
Posts: 60
Joined: Fri Jan 23, 2009 11:20 am

Re: Asset Manager lags with over 4000 images

Post by rpb3 » Tue May 10, 2011 9:21 am

Has anyone made any progress on this?

I am converting an old ASP site to Able 7.0.7 and he has 80,000 + images all named by product number.

The AssetManager.aspx page is useless the way it is now.

*** UPDATE : if anyone is interested, I ended up writing custom pocedures to add paging capability to the repeater that lists the files on that page. It was a bit of work, if you're interested in it, PM me.

User avatar
AbleMods
Master Yoda
Master Yoda
Posts: 5170
Joined: Wed Sep 26, 2007 5:47 am
Location: Fort Myers, Florida USA

Re: Asset Manager lags with over 4000 images

Post by AbleMods » Wed May 11, 2011 7:22 am

Yeah the asset manager needs some love to be of any use at all in larger installs. I gave up using it long ago, my site has about 200,000 images.

Breaking up into sub-folders made things easier to manage overall but asset manager still kept timing out so I gave up :)
Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com

rpb3
Lieutenant (LT)
Lieutenant (LT)
Posts: 60
Joined: Fri Jan 23, 2009 11:20 am

Re: Asset Manager lags with over 4000 images

Post by rpb3 » Mon May 16, 2011 9:39 am

I ended up adding paging to the left "sidebar" / file list. It took a bit of work to get it to work with the file details section and file picker but it seems to be working pretty well. Probably still needs some tweaking but I haven't found any problems yet, knock on wood.

PM me if your interested to know what I did.

Image

Post Reply