BV Commerce Forum
»
BV Commerce Support
»
General Support
»
Do I Need Two Dedicated Server to Run BV Commerce 5 ?
Rank: Member
Joined: 10/4/2007(UTC)
Posts: 20
|
Does it require to have two dedicated server to run BV Commerce 5? Like one for program server and one for Data Base server?
|
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 2,136
Was thanked: 1 time(s) in 1 post(s)
|
No it is not required. But you will achieve the best possible performance for your website if you keep the web server (running IIS) and the database server (running SQL Server) on separate hardware. |
|
|
|
|
|
|
Rank: Member
Joined: 10/4/2007(UTC)
Posts: 20
|
My program server and database server are spepared with quite a distance, one at the east coast and other at the west coast, for performance wise,
1. Should I just pick one of the server to put the BV 5 programs and database at the same machine?
2. Or just let program server and database server seperated, even they are far apart?
For performance wise, which one will be better?
|
|
|
|
|
|
Rank: Member
Joined: 8/1/2007(UTC)
Posts: 310
|
Hello Bill,
There are several things here. Let me explain.
1. For best performance, it is advisable to go for Web application on one server and the database on another server. If you decide to go this route, then I will recommend you to have both the servers on a private rack so that they can communicate with each other real fast. If one of your server is with one ISP and the second one is with another ISP, then it will induce a lot of delay and degrade the performance of your site. Instead of this, I will recommend you to go with the web application and the database on one server.
2. Another question - do you want to go for a dedicated server or shared hosting? It depends on how customized or complicated your site is, how many products you have, what additional services, if any do you intend to host.
You dont really need a dedicated server if the following are true:
1. If you do not 10K+ products
2. If you do not receive atleast 50 orders
3. If you do not want to host any additional services (windows services)
4. If your site is not customized and is not resource/processor intensive
If the above are true, then shared hosting on a good machine might be sufficient for you. When I say a good machine, look out for a machine with decent specs (at least 2 dual core Xeon procs, 4-8 GB RAM, 100 GB Bandwidth, Gbps uplink, etc). Most of the hosters provide low end machines for web hosting and that brings the performance down.
Let me know if you have further questions. |
Thanks,
Satya
support @ bayquel.net
Work: +1 803 883 3226 |
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 2,136
Was thanked: 1 time(s) in 1 post(s)
|
Originally Posted by: "Great Bill" 
My program server and database server are spepared with quite a distance, one at the east coast and other at the west coast, for performance wise,
1. Should I just pick one of the server to put the BV 5 programs and database at the same machine?
2. Or just let program server and database server seperated, even they are far apart?
For performance wise, which one will be better?
The recommendation to separate the web and database servers assumes that the 2 servers are connected by a high speed connection such as a LAN (local area network).
The latency caused by the separation of servers in your example would overwhelm any performance gained by separating the servers. Use #1.
|
|
|
|
|
|
|
Rank: Member
Joined: 10/4/2007(UTC)
Posts: 20
|
Typically, I have more than 40,000 items, I'm just trying to use BV 5 shopping cart as an easy way for our customers to place order with correct pricing break, shipping & handling cost , payment information like credit card, prepay check or purchase order. All online orders will be processed off line, we don't need any inventory control, vendor, or manufacturer information in BV 5, although BV 5 already have those fields, we just leave it there at no touch. If we put the BV 5 program server and database server at seperated machine but at the same ISP. Is that what BV 5 can handle?
|
|
|
|
|
|
Rank: Member
Joined: 8/1/2007(UTC)
Posts: 310
|
Have you tried shared hosting your site on a decent profile hardware? How does it perform?
Yes, BV5 can handle web and databases on different servers. Yes, you can go for web server and database server at the same ISP. However, I am not sure if it is really required. Try it out on a test domain on a good machine. See if that suffices your requirement. If so, then you dont need dedicated servers. If the site is sluggish, you might want to consider dedicated servers.
If you need a test domain on a beefy machine, let me know. I can host something up for you fairly quickly. |
Thanks,
Satya
support @ bayquel.net
Work: +1 803 883 3226 |
|
|
|
|
|
Rank: Member
Joined: 10/4/2007(UTC)
Posts: 20
|
The main concern is the performance! I have a big number of items, 40,000+! Is that realistic for BV5 to handle? Any member have more than 40,000+ with multiple pricing break and have a great performance handling by BV 5?
As my passed experience, the share hosting database server, the performance is too bad!
|
|
|
|
|
|
Rank: Member
Joined: 8/1/2007(UTC)
Posts: 310
|
BV5 can handle the number of products you are asking for. Do you have an email address or a phone number that I can reach you at? Alternatively, you can email me or call me at 803 883 3226. I have a test site with 8K products. For your purpose, what you really need to do is try it out. Try populating 40K products and then see what the performance is like. I dont think there are many BV stores with 40K products. There should be a few but individual store owners needs to respond back to you on that one.
When you say 40K products, are you saying 40K distinct products or are you including multiple SKUs of the same product as well? Please advise. |
Thanks,
Satya
support @ bayquel.net
Work: +1 803 883 3226 |
|
|
|
|
|
Rank: Member
Joined: 10/4/2007(UTC)
Posts: 20
|
We have 40,000+ individual items with apx. 100 individual categories, all with multiple pricing break. But not on the shopping cart yet! We don't have enough data on hand can populate to your test site. We just try to get the best solution of what we can do with BV 5! If we can get some live sites running BV 5 with 40,000+ SKUs to check it out that will be helpful for our next project!
|
|
|
|
|
|
Rank: Member
Joined: 8/1/2007(UTC)
Posts: 310
|
Well, download the trial version. Install it on your local server. Populate some dummy products into it (to the extent you want) and then look at the performance.
If you cannot simulate 40K dummy products, then contact some one who can. Thats why I told you to get in touch with me.
Even though some one gives you a live store with 40K products, you cannot test all aspects of the store. You can only do that if you have a test store that you control and for which you are an admin. Does that make sense? |
Thanks,
Satya
support @ bayquel.net
Work: +1 803 883 3226 |
|
|
|
|
|
Rank: Member
Joined: 10/4/2007(UTC)
Posts: 20
|
What I need from our community is the hand on experinece of running large datebase 40,000+ items!
|
|
|
|
|
|
Rank: Member
Joined: 8/1/2007(UTC)
Posts: 310
|
Marcus,
Would it be possible for you to share any test matrix and test scenarios that you might have used for BV5 testing? What is the maximum number of products (along with their corresponding properties, modifiers, inputs, etc) that BV5 was tested for? Is there any known limitation?
Is there any tool (internal/external) that you used to simulate such loads? Please advise. |
Thanks,
Satya
support @ bayquel.net
Work: +1 803 883 3226 |
|
|
|
|
|
Rank: Member
Joined: 12/23/2003(UTC)
Posts: 909
|
There's quite a few sites over at www.resposio.com with catalogs of that size and much larger. |
|
|
|
|
|
|
Rank: Member
Joined: 8/1/2007(UTC)
Posts: 310
|
Do we know what they are and how many products they have? |
Thanks,
Satya
support @ bayquel.net
Work: +1 803 883 3226 |
|
|
|
|
|
Rank: Member
Joined: 12/23/2003(UTC)
Posts: 909
|
Great Bill could contact www.Resposio.com for more in depth questions. |
|
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 1,786
|
We expect normal catalogs to be up to 250,000K products. We have had customers with catalogs in the 1M+ range but that may take some tweaks to database indexes and search routines, etc.
Product variants per product for inventory tracking are capped at 100 but that is controlled by the MaxVariantCombinations setting in the bvc_WebAppSetting table. If you have a fast machine or small catalog you can bump this up to a higher number.
There is no limit on Modifiers which create variants that are not used for inventory tracking or custom SKUs.
|
|
|
|
|
|
Rank: Member
Joined: 10/4/2007(UTC)
Posts: 20
|
Any member can suggest some great sites running large datebase 40,000+ items?
|
|
|
|
|
|
Rank: Member
Joined: 11/13/2004(UTC)
Posts: 189
|
I'm sure Resposio can point you towards those kinds of sites. |
|
|
|
|
|
|
Rank: Member
Joined: 11/6/2003(UTC)
Posts: 1,903
|
Great Bill, we have dozens of clients with over 100,000 SKUs in their catalogs. Many with over 250,000 SKU's. Don't worry about BV handling it, if you are on good hardware that is configured correctly 40,000 will be no problem at all.
If you contact me directly I can give you some examples. |
Noah |
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.