Results 1 to 2 of 2

Thread: ASP and MySQL

  1. #1
    Join Date
    Dec 1969

    Default ASP and MySQL

    Okay, this is kinda an asp question and kinda an sql question.<BR><BR>When accessing MySQL from an ASP page thru a DNS connection, does it allow more than one session at a time? Does it lock the file until the first user is finished?<BR><BR>I have a problem with using MSAccess for this reason, because it is not set up to work with JET and locks the file once it has been accessed by another user for the period of time that it is open.<BR><BR>Will this also be a problem with MySQL? I can&#039;t seem to find the answer anywhere!<BR><BR>Help! Please!<BR><BR>Siobhan

  2. #2
    Join Date
    Dec 1969

    Default RE: ASP and MySQL

    you can use locks, adlockpessimistic (only locks when actually updating), or adlockpessimistic (locks the record in use).<BR><BR>if you&#039;re using an access db, try short db accesses; i.e connect, execute the RS, dump into an array, close &null RS, close and null CN.<BR><BR>This reduces the number of concurrent calls to the db and improves performance no end.<BR><BR>If you&#039;re locking the file unintentionally, using MySQL should produce improvements.

Posting Permissions

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