dcsimg
A Flash Developer Resource Site

Results 1 to 3 of 3

Thread: Question for some of the real pros

  1. #1
    Senior Member
    Join Date
    Jul 2000
    Posts
    336
    I might possibly be designing a site for a pretty high traffic site soon. Most of the work I have done thus far has been very low traffic, specific use stuff.

    My question is, should there a be a concern about accessing data via ASP scripts from an access database? At high times, I believe this site can reach 100,000 hits a day. I am not real sure about how the Access database will work if the ASP is trying to access it simultaneously many times.

    Can someone fill me in on a little info of how this works?

    Thanks

    .fe.

  2. #2
    Senior Member
    Join Date
    May 2002
    Posts
    248
    You should read up about different lock types and how to set/change them. You can set it so that when the script opens a particular record to alter it, it is locked to other requests for it with a specific wait time (let's say 3 seconds). I don't know much about it, but that's my guess on what to research.

    -Dan

  3. #3
    chatbugs.com ***** flashTampaDotCom's Avatar
    Join Date
    Mar 2002
    Location
    Tampa, Florida
    Posts
    171
    If 100,000 hits or requests to an ACCESS database a day are realistic, unless you have a monster server (with very fast I/O), I STRONGLY recommend going with SQL2000.

    ASP Code conversion to SQL is almost a joke, its easy, and setting up the DB in SQL is wonderfully simple.

    The above is cautionary to the missing facts like the # of fields, query types, and/or the number of records to be returned from that many requests.

    If you start out a site with that traffic, in can only get higher, right? So, implement a scalable strategy NOW, before the project gets bigger, and you have users jumping up and down that the site seems slow. Been there, and done that!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  




Click Here to Expand Forum to Full Width

HTML5 Development Center