Professional Web Applications Themes

update problem - ASP Database

xarrisx wrote:  <snip>  The connection type does not matter. However, if you are not using the native Jet OLEDB provider, I suggest you do so. See www.able-consulting.com/ado_conn.htm for examples. You are falling victim to a performance enhancement in Jet: update-caching. I'm a little surprised about this as you are not using a cursor to do your insert. However, see these KB articles: http://support.microsoft.com/?kbid=240317 http://support.microsoft.com/kb/200300 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"...

  1. #1

    Default Re: update problem

    xarrisx wrote: 
    <snip> 

    The connection type does not matter. However, if you are not using the
    native Jet OLEDB provider, I suggest you do so. See
    www.able-consulting.com/ado_conn.htm for examples.

    You are falling victim to a performance enhancement in Jet: update-caching.
    I'm a little surprised about this as you are not using a cursor to do your
    insert. However, see these KB articles:
    http://support.microsoft.com/?kbid=240317
    http://support.microsoft.com/kb/200300


    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 Guest

  2. #2

    Default update problem

    I am using an Insert command in my asp code that Inserts a rows in my
    database.
    After the Insert command i create a recordset and ask for all the rows in
    the table that i aplied the insert command
    Some times the rows i get are correct but sometimes the database is not
    updated by the time the recordset is opened.

    Is there any way to wait until the table is updated with the new rows and
    then open the
    recordset?

    <%
    Dim Cmd_insord
    set Cmd_insord = Server.CreateObject("ADODB.Command")
    Cmd_insord.ActiveConnection = mystring
    Cmd_insord.CommandText = "INSERT INTO PP3 (order_status) VALUES (0) "
    Cmd_insord.CommandType = 1
    Cmd_insord.CommandTimeout = 0
    Cmd_insord.Prepared = true
    Cmd_insord.Execute() 'here i execute the insert command
    %>
    <%
    Dim RS_ORDER
    Set RS_ORDER = Server.CreateObject("ADODB.Recordset")
    RS_ORDER.ActiveConnection = MM_connDUgallery_STRING
    RS_ORDER.Source = "SELECT * FROM PP3 WHERE order_status=0"
    RS_ORDER.CursorType = 0
    RS_ORDER.CursorLocation = 2
    RS_ORDER.LockType = 1
    RS_ORDER.Open() ' when the program reaches here the PP3 table may not
    allready contain the new added records
    %>

    I am using access and dsnless conection


    xarrisx Guest

  3. #3

    Default Re: update problem


    "Bob Barrows [MVP]" <SPAMcom> wrote in message
    news:phx.gbl... 
    > <snip> 
    >
    > The connection type does not matter. However, if you are not using the
    > native Jet OLEDB provider, I suggest you do so. See
    > www.able-consulting.com/ado_conn.htm for examples.
    >
    > You are falling victim to a performance enhancement in Jet:[/ref]
    update-caching. 
    thanks for the link
    http://support.microsoft.com/?kbid=240317

    Searching for more info on "JetEngine object's RefreshCache Method" i found
    the following:

    I adjust this setting to the registry

    Go HKEY_LOCAL_MACHINE/Software/Microsoft/Jet/4.0/Engines/Jet/4.0/
    ImplicitCommitSync should be set to yes
    UserCommitSync should be set to yes.


    As it mentions it has some performance penalty but it works fine

    I suppose this affects all web sites in my web server. I am now looking for
    a function to add in my asp code that will immediately refresh the
    read-cache after the insert in my current connection.


    xarrisx Guest

Similar Threads

  1. Problem with IIS update
    By client crl in forum ASP.NET Security
    Replies: 0
    Last Post: February 7th, 11:39 AM
  2. SQL Update problem
    By TomD in forum ASP Database
    Replies: 2
    Last Post: February 13th, 03:16 PM
  3. inker problem (an update to the 'general problem')
    By eRez in forum Macromedia Director 3D
    Replies: 0
    Last Post: December 29th, 12:26 PM
  4. Update to 7.0.1 problem
    By John M in forum Adobe Photoshop 7, CS, CS2 & CS3
    Replies: 0
    Last Post: August 14th, 06:01 AM

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