Professional Web Applications Themes

Access 2000 or SQL Server 2000 - ASP Database

Hi I am planning to design a database (destined for the web) that will have between 20000 and 45000 records in it and will receive a lot of reads but very very few writes (just from me). Now the question is should I use: 1) The combination of Access 2000 (accessible through ASP or ASP.NET) using OLEDB Jet or 2) SQL Server 2000 ? Of course I know that the SQL Server option is a better one, especially since it's said that an Access DB can have about 9 users or so accessing it at the same time. But is ...

  1. #1

    Default Access 2000 or SQL Server 2000

    Hi

    I am planning to design a database (destined for the web) that will have
    between 20000 and 45000 records in it and will receive a lot of reads but
    very very few writes (just from me).

    Now the question is should I use:

    1) The combination of Access 2000 (accessible through ASP or ASP.NET) using
    OLEDB Jet

    or

    2) SQL Server 2000 ?

    Of course I know that the SQL Server option is a better one, especially
    since it's said that an Access DB can have about 9 users or so accessing it
    at the same time. But is that a general rule or is it about many people
    writing to the DB? In other words, if an Access DB has hardly any writes
    and 99.9% reads can it be used as efficiently as it would be used on SQL
    Server 2000?



    Denis Guest

  2. #2

    Default Re: Access 2000 or SQL Server 2000

    Denis,

    For mostly read access, a properly optimized local Jet (Access) database
    should offer performance similar to that of a local SQL Server database, and
    better than that of a SQL Server database on another machine.

    That said, the number of concurrent connections present a hard limitation
    with Jet. For mostly read access, you can definitely exceed 9 concurrent
    connections. The hard upper limit is 255, but it's very difficult to reach
    in practice. Even with mostly read access, 50-100 concurrent connections is
    a much more realistic goal. This doesn't mean that Jet would necessarily be
    unsuitable, but you might want to put more weight on your answers to the
    following questions than on the performance issue:

    1. How many concurrent users do you expect?
    2. How would you rate your skills in sufficiently optimizing a Jet database
    for this type of access? (i.e.: How much time are you going to lose with
    this?)
    3. How difficult and/or time consuming would it be for you to convert to
    SQL Server if this becomes necessary?

    In particular, compare the likely costs of #2 and 3 to the cost of
    immediately implementing SQL Server instead. You might find that it's just
    not worth considering Jet at all...

    HTH,
    Nicole


    "Denis" <k9kondophotmail.com> wrote in message
    news:O5Fka304DHA.2556TK2MSFTNGP09.phx.gbl...
    > Hi
    >
    > I am planning to design a database (destined for the web) that will have
    > between 20000 and 45000 records in it and will receive a lot of reads but
    > very very few writes (just from me).
    >
    > Now the question is should I use:
    >
    > 1) The combination of Access 2000 (accessible through ASP or ASP.NET)
    > using
    > OLEDB Jet
    >
    > or
    >
    > 2) SQL Server 2000 ?
    >
    > Of course I know that the SQL Server option is a better one, especially
    > since it's said that an Access DB can have about 9 users or so accessing
    > it
    > at the same time. But is that a general rule or is it about many people
    > writing to the DB? In other words, if an Access DB has hardly any writes
    > and 99.9% reads can it be used as efficiently as it would be used on SQL
    > Server 2000?
    >
    >
    >

    Nicole Calinoiu Guest

Similar Threads

  1. ASP.NET access denied to SQL Server 2000
    By Jan Bannister in forum ASP Database
    Replies: 2
    Last Post: December 23rd, 06:47 PM
  2. Minimal permissions with an Access Database and 2000 server ?
    By Gilles LAMBERT in forum ASP.NET Security
    Replies: 2
    Last Post: October 23rd, 04:42 AM
  3. Replies: 1
    Last Post: September 5th, 08:55 PM
  4. Replies: 0
    Last Post: September 5th, 01:50 PM
  5. Replies: 0
    Last Post: July 6th, 06:05 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139