Professional Web Applications Themes

How does Access database handle concurrent updates? - ASP Database

When a number of calls are made to update (add records, update field) at the same time what does MS Access do to handle the calls? Does Mysql with php handle similar calls better?? Thanks...

  1. #1

    Default How does Access database handle concurrent updates?

    When a number of calls are made to update (add records, update field)
    at the same time what does MS Access do to handle the calls?

    Does Mysql with php handle similar calls better??

    Thanks
    Perdit Guest

  2. #2

    Default Re: How does Access database handle concurrent updates?


    I think MySQL with any script would handle it better ... in this case,
    I don' t think you have to worry quite as much about the scripting
    language, but be worried about the performance of the database. MySQL
    is a pretty nice DB made to handle wuite a bit more than Access
    (although I still prefer MS SQL)

    On 11 Jan 2004 06:26:33 -0800, [email]cftranslatehotpop.com[/email] (Perdit) wrote:
    >When a number of calls are made to update (add records, update field)
    >at the same time what does MS Access do to handle the calls?
    >
    >Does Mysql with php handle similar calls better??
    >
    >Thanks
    Brynn Guest

  3. #3

    Default Re: How does Access database handle concurrent updates?

    Perdit wrote:
    > When a number of calls are made to update (add records, update field)
    > at the same time what does MS Access do to handle the calls?
    Pretty much the same thing most rdbms's do: it encapsulates them in
    transactions and applies appropriate locks to the tables involved to make
    sure none of them step on each other until each transaction is committed.

    Bob Barrows
    --
    Microsoft MVP - ASP/ASP.NET
    Please reply to the newsgroup. This email account is my spam trap so I
    don't check it very often. If you must reply off-line, then remove the
    "NO SPAM"


    Bob Barrows Guest

Similar Threads

  1. CF File Access Broken /w Win Server 2003 Updates
    By binxsta in forum Coldfusion Server Administration
    Replies: 0
    Last Post: December 20th, 07:26 PM
  2. Invalid database handle RBD
    By click007 in forum Coldfusion Database Access
    Replies: 1
    Last Post: November 3rd, 05:10 PM
  3. Replies: 11
    Last Post: July 8th, 01:51 PM
  4. How does the OLEDB driver handle RS Updates?
    By John Beschler in forum ASP Database
    Replies: 7
    Last Post: October 16th, 10:50 AM
  5. what is the correct way to handle empty database returns?
    By lawrence in forum PHP Development
    Replies: 4
    Last Post: September 16th, 09:30 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