Results 1 to 5 of 5
  1. #1
    cgschlangen
    Guest

    ASP Database Question

    Okay - I guess I have two questions... I've just gotten to the point where I'm fairly comfortable w/ ASP, and I'm getting requests for a lot of systems to be built...

    1) I've heard arguments that Microsoft Access databases are too large to be used in major ASP Applications... Are they? If not MS Access then what other options are there - and which is most preferred?

    2) I know it's not smart to store images in databases - simply because MS Access makes a .bmp copy for it's own records on top of the jpg (or whatever) and can inflate your database size greatly. If a database is only used for it's tables:
    a) is it possible to store images in databases via ASP? (Guess I should ask this first [img]/forums/images/smilies/tongue.gif[/img] )
    [img]/forums/images/smilies/cool.gif[/img] will it increase the database size by creating duplicate copies of the image? (even though it's not being called by anything in Access?) - If I'm not using Access are there any concerns?

    Thanks in advance
    Dan

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ASP Database Question

    Hi Dan,

    You've asked some very good questions. Here are some answers and thoughts to consider. The interesting thing about ASP development is that there is not necessarily one correct road to travel. With that said, here are my opinions...

    1) Access databases are not "too large to be used", however the determining factor of whether to use Access or a larger database (such as SQL Server) is the amount of simultaneous users. If you are expecting more than 3-5 simultaneous writing users I would recommend exploring something more robust. Access can typically support many more read-only users with no problems. I typically use Access databases for web-apps where SQL is not available (or overpriced), but I always use SQL when it's available (at my job).

    2) You are correct in thinking that it's typically a bad idea to store graphics inside Access. A much better alternative is to store the pictures as files, then store a reference (text path or link) to the files in the database. For help in uploading these files, you might consider using ASPSmart's free ASPSmart Upload component. It's worked very well for me in the past.

    Hope this helps <img src=/S/salute.gif border=0 alt=salute width=15 height=20>

  3. #3
    cgschlangen
    Guest

    Re: ASP Database Question

    Mark,
    Thanks for the words of wisdom... I took a look at the link you provided and was very interested... However for users (like me) who don't have the capabilities of registering all the components involved - they might appreciate this link Pure ASP File Upload of Particular interest is the section "Update: Even Faster Yet..." which has a very spiffy little script which works like a charm (for me) - although I haven't had too much time to play with it...

    Thanks again
    Dan

  4. #4
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: ASP Database Question

    I got very good performance with an Access database on the same box as the web server. I wouldn't want to run the ADO process on the web server and have the MDB file on another server because too much data would have to pass over a slower connection. MS SQL Server (even MSDE) or MySQL would be better for a multiple-box scenario.

  5. #5
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ASP Database Question

    I should have mentioned - you'll want to check with your web host to see what ASP Components are already included. Even low-end web hosts offer at least some type of upload and email components.

    Hope this helps!

Posting Permissions

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