sewells
|
| Posted: 06/13/2003, 2:29 AM |
|
I could use advice and encouragement from the ccs community on a new client project much bigger than anything I've done before.
I've done 3 ccs projects, all of them working great for over a year. They were all built on ASP with MSACCESS as the underlying database on windows 2000 server hosts I managed. The biggest of the three was for a private school which registered 240 families over about a 2 week period.
I've got a new customer who now wants to build a online store similar to the bookstore ap that will have 10,000+ entires, about 1000-2000 registered customers, and about 100,000 hits the first year. They hope to grow from that. Now I realize that many startup .dot coms think they can take over the world, but I would like to plan for success.
here are some questiosn I'd like any offered feedback on:
- Can i develop and deploy on access and move to MS SQL when I need to or
should I bit the schedule bullet now and learn about MS SQL?
- What do I need to get smart on to use MS SQL with codecharge? Do i still
design and test under Access? If so, how do I convert? SQL97 or SQL
2000?
- I'll be using commercial web hosting. What are the issues (vs currently
I have admin access to my own servers and have done pretty much what ever
i need through remote access).
- Any recommendation on rock solid web hosts for ASP/SQL?
- How do I determine how much bandwidth I need and how much server space
I need?
I might be interested in hiring a "mentor" to advise me through the worst of this (not big bucks, but not bad for some advise). Any interested parties in consulting can email me atsteve@stevenwells.net
Thanks in advance
---Steve
|
|
|
 |
Admin - CodeChargers
|
| Posted: 06/13/2003, 6:11 AM |
|
First of all congrats on getting the job :) - Hope it all goes well for you ;)
> Can i develop and deploy on access and move to MS SQL when I need to or
> should I bit the schedule bullet now and learn about MS SQL?
Yes and No……. for a project of this size I would recommend developing with MS SQL from the beginning, as although you can transfer the code without to much of a hiccup, I think its it’s better to use the ‘production’ environment from day one.
Should you bite the bullet and learn now? Depends on the time scale you have to work in and the learning curve that you may have to understand all things beautiful and weird about MS SQL.
> What do I need to get smart on to use MS SQL with codecharge? Do i still
> design and test under Access? If so, how do I convert? SQL97 or SQL 2000?
‘If’ you’re unsure, about MS SQL (and providing it’s not a prerequisite of your clients to have it developed in it) why not develop the project in MS Access (which ‘could’ run a website easily enough – I have one with over 2000 members, and receives thousands of hits a day, but am to lazy to change it over). Get the site operational, and providing you don’t add to much custom code that needs to be re-entered / changed for MS SQL, use CCS to re-generate a MS SQL version for you to tweak and play with? Being able to re-generate projects in any language / use any backend is one of the finer qualities of CCS.
> I'll be using commercial web hosting. What are the issues (vs currently
> I have admin access to my own servers and have done pretty much what ever i need through remote access).
Cost….. MS SQL database can be expensive – read the small print and try to go for a host that offers it as part of the ‘package’ and not a ‘bolt-on’ ….. which often means give me more $$$
> Any recommendation on rock solid web hosts for ASP/SQL?
Yes – Check out http://CodeChargers.com – you may find a suitable host, or you can request a quote via the ISP / Hosts area.
>How do I determine how much bandwidth I need and how much server space I need?
How long is a piece of string? This is the million dollar question – without knowing the ‘make-up’ of the site…. Is it graphics intensive etc… it’s a hard one to measure. Again – when you select a host, try to get one that allows you to increase / grow as required – definetly don’t choose someone who ‘caps’ their bandwidth or one who suspends a site when the bandwidth level is reached….. There are a lot of them out there (read the TOS / AUP).
>I might be interested in hiring a "mentor" to advise me through the worst of this (not big bucks, but not bad for some advise). Any interested >parties in consulting can email me atsteve@stevenwells.net
Once again – why post a request on the ‘Job Offers and Requests’ section of CodeChargers? There’s a lot of talent out there, including a lot of good hearted people who may just help for free.
Sorry it's short and sweet - I'm sure others will advice you also.
Regards
Admin - CodeChargers
http://www.CodeChargers.com
Charging Up!
|
|
|
|
|
