Re: New to DB Development

From: Jim (jim_at_hotmail.com)
Date: 03/22/04 

Date: Mon, 22 Mar 2004 17:51:07 -0600

Jeff,

I'm sorry but I need you to comment further on, "A batch file with a COPY
command and the use of the Windows scheduling service will accomplish
that task in a few minutes, with little or no overhead and no learning
curve to speak of."

I don't understand what you are talking about here. My knowledge of the
Windows OS is very weak.

"Jeff Cochran" <jcochran.nospam@naplesgov.com> wrote in message
news:405f0d46.88039974@msnews.microsoft.com...
> On Sun, 21 Mar 2004 17:56:26 -0600, "Jim" <jim@hotmail.com> wrote:
>
> >I am new to developing Webs that contain databases and want to get off to
> >the right start. I am hoping someone will take some of their valuable
time
> >to answer.
> >
> >How much more difficult is it to "start" with SQL Server than Access?
>
> For web use you won't be dealing with the Access interface, so the
> differences become much smaller. If your host supports it, MS SQL is
> a great start. But a caveat, web design with a database isn't
> database design, and you'll need to master database design to do the
> web interface efficiently.
>
> >None of the Webs I design, at least until now, need any transactional
> >processing. A few sites do get over 50,000 hits a month and I worry that
any
> >DB I add to a site might bog it down.
>
> With Access you'd probably be right. MS SQL isn't really an issue
> with that traffic level, your bandwidth will likely be the bottleneck.
> Provided you design the database and coce efficiently of course.
>
> >My primary reason for adding a DB is
> >to start a scheduling process for some of the sites to bring in and out
> >various elements (text, photos color changes) at predetermined times.
>
> That's a lame reason. No really, it is. A batch file with a COPY
> command and the use of the Windows scheduling service will accomplish
> that task in a few minutes, with little or no overhead and no learning
> curve to speak of.
>
> If your site were truly dynamic, serving data appropriate to the time
> and user on a continuous basis, then a database is needed.
>
> Jeff

Relevant Pages

  • Re: id key start with 22?
    ... accomplish. ... > Help to design a database ... Prev by Date: ...
    (microsoft.public.access.tablesdbdesign)
  • Allow Developer to Design tables, but not be owner?
    ... I have some developers that I need to be able to do anything to the Database ... They need to still create and design existing tables. ... How can I accomplish ...
    (microsoft.public.sqlserver.security)
  • C# programmer looking for a job
    ... Software Development including Desktop, Client/Server and Database ... Practical skills in object oriented design and design patterns ... XML, Oracle, CVS, VSS, Delphi, bug tracking. ... Developed in Delphi5; ...
    (misc.immigration.usa)
  • Re: O/R Mapper
    ... | - create E/R model from niam model ... classes that contain, not only data, but also functionality as OO design is ... a database where they do not exist in the object model is corrupting the ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Date range on reports
    ... > box to your report with a control source like: ... >> In the Database window (Database window: The window that appears when you ... >> In the New Form dialog box, click Design View, and click OK. ... >> Begin by clicking Macro Names to display the Macro Name column. ...
    (microsoft.public.access.reports)