Cross: Access speed

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Igor

    #1

    Cross: Access speed

    Can I use access for big database (cca 10-30 MB, cca 10-30k lines in
    database). It will be asp.net 2.0 aplication and very fast server. Mostly
    simple transactions (like SELECT * From Books Where Name like 'SomeName%').

    Can it be problem if I have 10 000 unique visitors per day? I see that many
    big sites have access database. Is it ok, ir it is big risk?


  • =?ISO-8859-1?Q?Arne_Vajh=F8j?=

    #2
    Re: Cross: Access speed

    Igor wrote:
    Can I use access for big database (cca 10-30 MB, cca 10-30k lines in
    database). It will be asp.net 2.0 aplication and very fast server. Mostly
    simple transactions (like SELECT * From Books Where Name like 'SomeName%').
    >
    Can it be problem if I have 10 000 unique visitors per day? I see that many
    big sites have access database. Is it ok, ir it is big risk?
    Assuming that:
    - you have index on Name column
    - the MDB is on a local disk
    - the disk is not heavily used by something else
    - the unique visitors only make one query (or only a few)
    - the load is reasonable good distributed over time
    then it should not be a problem.

    30 MB can easily be cached in disk/file cache.

    10000/day is only 7/minute over 24 hours or 21/minute over
    8 hours and that is not heavy.

    Arne


    Comment

    • sloan

      #3
      Re: Cross: Access speed


      You might want to cache items that are very often run (but seldom change)
      queries.

      There is a Cache object in the System.Web namespace.

      You can also find an object called "WeakRefere nce" which is a way to cache
      items, but to release them if there is a memory drain.

      I wouldn't start with Access. I'd start with MSDE (2000) or Sql Express
      (2005).

      But you might be able to pull it off.



      "Igor" <igor@nesalji.h rwrote in message
      news:emr8st$t2b $1@sunce.iskon. hr...
      Can I use access for big database (cca 10-30 MB, cca 10-30k lines in
      database). It will be asp.net 2.0 aplication and very fast server. Mostly
      simple transactions (like SELECT * From Books Where Name like
      'SomeName%').
      >
      Can it be problem if I have 10 000 unique visitors per day? I see that
      many
      big sites have access database. Is it ok, ir it is big risk?
      >
      >

      Comment

      • Cor Ligthert [MVP]

        #4
        Re: Cross: Access speed

        Igor,

        It is the same as the others wrote, however probably easier to manage.

        You can set a dataset shared in your program. Because all your users share
        the same application is that for all your users. It has to be a dataset that
        from the userside will never be changed otherwise you should never create a
        shared dataset in an AspNet appliction.

        Don't forget to make an extra page to set the dataset to nothing, otherwise
        you can never change it.

        Cor

        "Igor" <igor@nesalji.h rschreef in bericht
        news:emr8st$t2b $1@sunce.iskon. hr...
        Can I use access for big database (cca 10-30 MB, cca 10-30k lines in
        database). It will be asp.net 2.0 aplication and very fast server. Mostly
        simple transactions (like SELECT * From Books Where Name like
        'SomeName%').
        >
        Can it be problem if I have 10 000 unique visitors per day? I see that
        many big sites have access database. Is it ok, ir it is big risk?
        >

        Comment

        • Rotsey

          #5
          Re: Cross: Access speed

          use SQL Express, it is free and durable

          "Igor" <igor@nesalji.h rwrote in message
          news:emr8st$t2b $1@sunce.iskon. hr...
          Can I use access for big database (cca 10-30 MB, cca 10-30k lines in
          database). It will be asp.net 2.0 aplication and very fast server. Mostly
          simple transactions (like SELECT * From Books Where Name like
          'SomeName%').
          >
          Can it be problem if I have 10 000 unique visitors per day? I see that
          many big sites have access database. Is it ok, ir it is big risk?
          >

          Comment

          • Cor Ligthert [MVP]

            #6
            Re: Cross: Access speed

            use SQL Express, it is free and durable
            >
            Hi Igor,

            Are you from the Netherlands?

            Cor


            "Igor" <igor@nesalji.h rwrote in message
            news:emr8st$t2b $1@sunce.iskon. hr...
            >Can I use access for big database (cca 10-30 MB, cca 10-30k lines in
            >database). It will be asp.net 2.0 aplication and very fast server. Mostly
            >simple transactions (like SELECT * From Books Where Name like
            >'SomeName%') .
            >>
            >Can it be problem if I have 10 000 unique visitors per day? I see that
            >many big sites have access database. Is it ok, ir it is big risk?
            >>
            >
            >

            Comment

            • Igor

              #7
              Re: Cross: Access speed

              Hi Igor,
              >
              Are you from the Netherlands?
              No, I am from Croatia!


              Comment

              • Igor

                #8
                Re: Cross: Access speed

                Assuming that:
                - you have index on Name column
                What index?
                - the MDB is on a local disk
                It is on web hosting account like www.webhost4life.com. It is on fast server
                (i hope that it is true).
                - the disk is not heavily used by something else
                It is shared hosting, but good hosting.
                - the unique visitors only make one query (or only a few)
                One or few queries in one page load.
                - the load is reasonable good distributed over time
                Distribution... hmm. It is for tourist agency. Visitors mostly come at
                summer. I don't know how many often at different hours.
                30 MB can easily be cached in disk/file cache.
                Can I cashe this if it is not on my server. It is on shared hosting named
                webhost4life.co m or something simmilar (profesional hosting).
                10000/day is only 7/minute over 24 hours or 21/minute over
                8 hours and that is not heavy.
                What if 100 or 300 visitors come at the same second and every of them
                request 2-3 select queries?


                Comment

                • Cor Ligthert [MVP]

                  #9
                  Re: Cross: Access speed

                  I thought that you was Dutch, because there was asked about speed and you
                  are answering about the cost.

                  :-)

                  Cor

                  "Igor" <igor@nesalji.h rschreef in bericht
                  news:emtigs$v3j $1@sunce.iskon. hr...
                  >Hi Igor,
                  >>
                  >Are you from the Netherlands?
                  >
                  No, I am from Croatia!
                  >

                  Comment

                  • brooksr

                    #10
                    Re: Cross: Access speed

                    1. Go into Table view of the MDB containing the actual data.
                    2. Open the table in design mode.
                    3. Go to the bottom of the screen under the 'General' tab.
                    4. Find the Indexed property and set it to 'Yes" either with or without
                    duplicates, depending on your data.
                    (this may vary a little bit depending on your version of Access)

                    Brooks

                    Igor wrote:
                    Assuming that:
                    - you have index on Name column
                    What index?

                    Comment

                    • Igor

                      #11
                      Re: Cross: Access speed

                      4. Find the Indexed property and set it to 'Yes" either with or without
                      duplicates, depending on your data.
                      (this may vary a little bit depending on your version of Access)
                      Why indexed filed is important, because of speed or something else?


                      Comment

                      • Mark Rae

                        #12
                        Re: Cross: Access speed

                        "Igor" <igor@nesalji.h rwrote in message
                        news:emtod9$8qo $1@sunce.iskon. hr...
                        >4. Find the Indexed property and set it to 'Yes" either with or without
                        >duplicates, depending on your data.
                        >(this may vary a little bit depending on your version of Access)
                        >
                        Why indexed filed is important, because of speed or something else?
                        You *really* need to find a beginner's guide to databases... Indexes are
                        absolutely fundamental to database performance.

                        As others have pointed out, Access is not particularly suited to web
                        deployment but, if you're determined to use it, this might be a good place
                        to start:
                        http://www.amazon.com/Access-2003-Al...e=UTF8&s=books


                        Comment

                        • brooksr

                          #13
                          Re: Cross: Access speed

                          Yes, primarly for speed.

                          Mark is right, get Access for Dummies.

                          It is scary that you are trying to do this without more knowledge of
                          databases and Access. You are probably going to have further issues
                          ....

                          A STRONG Access developer may be able to make this work and will know
                          when it is time to move to SQL Server. A newbie ...

                          Brooks
                          Why indexed filed is important, because of speed or something else?

                          Comment

                          • Mark Rae

                            #14
                            Re: Cross: Access speed

                            "brooksr" <brooks@rimesrv .netwrote in message
                            news:1167234949 .458065.197980@ f1g2000cwa.goog legroups.com...
                            A STRONG Access developer may be able to make this work and will know
                            when it is time to move to SQL Server. A newbie ...
                            No chance whatsoever...


                            Comment

                            • RobinS

                              #15
                              Re: Cross: Access speed


                              "Mark Rae" <mark@markNOSPA Mrae.comwrote in message
                              news:uKvvOPdKHH A.4384@TK2MSFTN GP03.phx.gbl...
                              "brooksr" <brooks@rimesrv .netwrote in message
                              news:1167234949 .458065.197980@ f1g2000cwa.goog legroups.com...
                              >
                              >A STRONG Access developer may be able to make this work and will know
                              >when it is time to move to SQL Server. A newbie ...
                              >
                              No chance whatsoever...
                              >
                              That's not true. Sometimes people have dumb luck. ;-)

                              Robin S.


                              Comment

                              Working...