Support Forums

DGiscombe + · 01-26-2009, 07:38 PM

My client wants to display ads depending on what country is selected, and I know full well that this is a bad idea as I'm sure a lot of categories with (0) next to it

.

The only way I can think to make this happen is to make the countries as parent categories (23 of them!) and make a set of child/parent categories under each of them (64 I think).

So that makes it about 138 or categories. Will this seize the site up, or should I just advise them to buy a very very good dedicated server?

Mike-N-Tosh + · 01-26-2009, 08:07 PM

The number of categories that you have isn't really going have much affect on the server or the script. I wouldn't be concerned there.

-Mike

Eric Barnes · 01-26-2009, 08:46 PM

Really the only affect I have seen with tons and tons of categories is to turn of the number of category listings. The way these are pulled out is pretty intensive. Of course if you are getting a lot of ads it may be wise to use some type of server caching and so forth.

DGiscombe + · 01-27-2009, 04:34 PM

Is there an easier way to duplicate a batch of categories and setting them to a different parent?

At the moment I'm pressing the duplicate button, changing the slug to make it unique and changing the parent.

Is there an SQL solution to this?

Eric Barnes · 01-27-2009, 04:53 PM

I am sure that is possible. Although if you know a little php the best way may be to have your main categories but limit the listings displayed based off the country the selected. To go that route you would just look in the Listings class "getAllListings()" and modify the query.

DGiscombe + · 01-27-2009, 04:59 PM

I wouldn't know how to do that.

I'll carry on with this method then, 1200 to go :|

Mike-N-Tosh + · 01-27-2009, 07:13 PM

The easiest method would be if you have access to the mysql database directly with phpMyadmin. Just make the list in Excel. Save as a csv file. Import it in phpMyAdmin.

That's how I always set up new classifieds sites, because it's so much faster and easier to work with in Excel.

-Mike

01-26-2009, 07:38 PM	#1
DGiscombe + Graphic / Web Desginer Join Date: Nov 2008 Location: London, England Posts: 77 Rep Power: 14	how intensive would this be? My client wants to display ads depending on what country is selected, and I know full well that this is a bad idea as I'm sure a lot of categories with (0) next to it . The only way I can think to make this happen is to make the countries as parent categories (23 of them!) and make a set of child/parent categories under each of them (64 I think). So that makes it about 138 or categories. Will this seize the site up, or should I just advise them to buy a very very good dedicated server?

01-26-2009, 08:07 PM	#2
Mike-N-Tosh + Developer & Moderator Join Date: Jan 2007 Location: Pennsylvania, USA Posts: 2,426 Rep Power: 75	The number of categories that you have isn't really going have much affect on the server or the script. I wouldn't be concerned there. -Mike __________________ Mike-N-Tosh IndianaPC.org - A community website (v3.1.10 Developer - heavily modified & used as the CMS) Sandbox [localhost(v3.1.10, v4.0.9, 4.1.10,4.2,5.0)] for development and customization Visit My blog: reviews, tips, tricks, tutorials and my store with Templates, Mods & Docs Web Hosting \| Web Design & Development \| 68 Classifieds Customizations I am not a 68C employee, just a user and try to help out

01-26-2009, 08:46 PM	#3
Eric Barnes 68 Classifieds Staff Join Date: Mar 2006 Location: Belmont, NC Posts: 5,489 Rep Power: 136	Really the only affect I have seen with tons and tons of categories is to turn of the number of category listings. The way these are pulled out is pretty intensive. Of course if you are getting a lot of ads it may be wise to use some type of server caching and so forth. __________________ Eric Barnes 68 Classifieds Developer Customer Area \| Issue Tracker \| Documentation \| 68C Mods \| 68 @ Twitter \| My Modules

01-27-2009, 04:53 PM	#5
Eric Barnes 68 Classifieds Staff Join Date: Mar 2006 Location: Belmont, NC Posts: 5,489 Rep Power: 136	I am sure that is possible. Although if you know a little php the best way may be to have your main categories but limit the listings displayed based off the country the selected. To go that route you would just look in the Listings class "getAllListings()" and modify the query. __________________ Eric Barnes 68 Classifieds Developer Customer Area \| Issue Tracker \| Documentation \| 68C Mods \| 68 @ Twitter \| My Modules

01-27-2009, 07:13 PM	#7
Mike-N-Tosh + Developer & Moderator Join Date: Jan 2007 Location: Pennsylvania, USA Posts: 2,426 Rep Power: 75	The easiest method would be if you have access to the mysql database directly with phpMyadmin. Just make the list in Excel. Save as a csv file. Import it in phpMyAdmin. That's how I always set up new classifieds sites, because it's so much faster and easier to work with in Excel. -Mike __________________ Mike-N-Tosh IndianaPC.org - A community website (v3.1.10 Developer - heavily modified & used as the CMS) Sandbox [localhost(v3.1.10, v4.0.9, 4.1.10,4.2,5.0)] for development and customization Visit My blog: reviews, tips, tricks, tutorials and my store with Templates, Mods & Docs Web Hosting \| Web Design & Development \| 68 Classifieds Customizations I am not a 68C employee, just a user and try to help out

01-27-2009, 04:34 PM	#4
DGiscombe + Graphic / Web Desginer Join Date: Nov 2008 Location: London, England Posts: 77 Rep Power: 14	Is there an easier way to duplicate a batch of categories and setting them to a different parent? At the moment I'm pressing the duplicate button, changing the slug to make it unique and changing the parent. Is there an SQL solution to this?

01-27-2009, 04:59 PM	#6
DGiscombe + Graphic / Web Desginer Join Date: Nov 2008 Location: London, England Posts: 77 Rep Power: 14	I wouldn't know how to do that. I'll carry on with this method then, 1200 to go :\|

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Support Forums

how intensive would this be?

This topic is resolved.