Thread

I am scoping out a potential clients site and I’m wanting to use EE2 but I have never used it for high volume sites before.

The client runs auctions (at an auction house not online) and they want an online directory so people can see their new items up for auction.
The client would need to post around 1,000-2,500 entries per month with each post including:
multiple images (1-5 images likely within a Matrix field)
textarea(1-2)
text input box (2-4)
select boxes (1-3)
relationship field (1-2 likely with Playa 4). 

Vistors: 5,000-30,000 per month

All these posts need to be accessible for previous years so can’t just delete old posts every few months.
(only a very small portion of people will be looking at results older than 3 months/previous auctions)

Is this not even a concern or will I find real issues having over new 20,000 posts each year?

Or is there a smart way to move old posts to another table or database or somehow streamline it so all posts older that 4-6months are archived.

Cheers
Steve

I have never heard of this being an issue.  Also, caching can do a lot for keeping your queries to a minimum.

Is this not even a concern or will I find real issues having over new 20,000 posts each year?

I don’t think this will give you an issue. What you need to keep in mind is your hosting environment and how you build your site for performance (caching etc)

Thanks guys.  Really appreciate it.

Hey All,

I was hoping to piggyback on this thread, since I think my question is related.

I’m in the process of building a site which basically aggregates a bunch of event listings from various sources. There are about 8 authors who add new events daily, and that number will likely continue to grow. In addition, they have been getting large amounts of traffic (larger than I’m used to working with, anyway… about 30k monthly).

In short, what considerations do I need to make in order to ensure that the site runs as quickly and efficiently as possible? I’m familiar with EE’s caching settings, and I think I know a few best practices, but I’m also a fairly inexperienced developer and I’d like to see if there are any resources out there for running EE as efficiently as it can.

Any tips and/or resources would be greatly appreciated!

OK… I did find this resource in another thread, so if this is the “definitive guide” I may have found an answer to my own question. It would help to know which of these tips would have the biggest impact, though.

http://www.slideshare.net/unruthless/make-your-site-speedy

That is a useful slideshow.

The biggest I’ve found are caching, gzip/mod_deflate content/js/css and then removing embeds and switching to snippets.  But be aware that if you have big snippets then it can have a reverse effect.  Sometimes an embed works better or find another way around it.  Low Variable is sometimes another option that I’ve heard people using.

Also disabling tracking and unused tag functions/queries helps decrease sql queries. e.g.

{exp:channel:entries disable="member_data|categories|trackbacks|pagination" ...}

Best just to try each different one and record your changes using the debug mode.  I’ve found this really useful.

Hope this helps.

Hey dev82, I was aware of that diable parameter but the rest is exactly what I was looking for. Very helpful, thanks much!