Can I use a [closedatabase] inside an [exclusivelock]?

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 35064
interpreted = N
texte = I have a database to keep track of the number of hits on the various ads in various sites on my server. So whenever anyone hits any of the pages with any of the ads, a [replace] occurs in the database. As a result it is the most busy database on our server. However I occasionally need to append new ads to the database, and because of the heavy traffic due to the replaces, during peak hours, any append waits for the 20 seconds specified in the admin area for the busy database and then quits. To solve this problem, I intend to use a combination of [spawn] and [exclusivelock] to create a new thread and have an exclusive connection with the database for appending. The code will be along the following lines.[spawn] [ExclusiveLock db=mydb.db][append db=mydb.db]bunch of stuff from formvariables[/append][closedatabase db=mydb.db][/ExclusiveLock] [/spawn]I have two questions reagrding the above code:1. Will the new thread created using the [spawn] be able to achieve a higher priority over the other attempts to [replace] the database because it has an [exclusivelock]?2.Can I have a [closedatabase] inside a [exclusivelock]?Any answers/suggestions/heads-up is appreciated. TIA.-Jai. Jaishankar Jayaram, Database Architect, Interactive Ink, Inc. Phone: (614) 221-7089 ext 23 Fax: (614) 221-7098 mailto:jai@interactiveink.com http://www.interactiveink.com E-business made Easy------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Can I use a [closedatabase] inside an [exclusivelock]? (Jaishankar Jayaram 2000)
I have a database to keep track of the number of hits on the various ads in various sites on my server. So whenever anyone hits any of the pages with any of the ads, a [replace] occurs in the database. As a result it is the most busy database on our server. However I occasionally need to append new ads to the database, and because of the heavy traffic due to the replaces, during peak hours, any append waits for the 20 seconds specified in the admin area for the busy database and then quits. To solve this problem, I intend to use a combination of [spawn] and [exclusivelock] to create a new thread and have an exclusive connection with the database for appending. The code will be along the following lines.[spawn] [ExclusiveLock db=mydb.db][append db=mydb.db]bunch of stuff from formvariables[/append][closedatabase db=mydb.db][/ExclusiveLock] [/spawn]I have two questions reagrding the above code:1. Will the new thread created using the [spawn] be able to achieve a higher priority over the other attempts to [replace] the database because it has an [exclusivelock]?2.Can I have a [closedatabase] inside a [exclusivelock]?Any answers/suggestions/heads-up is appreciated. TIA.-Jai. Jaishankar Jayaram, Database Architect, Interactive Ink, Inc. Phone: (614) 221-7089 ext 23 Fax: (614) 221-7098 mailto:jai@interactiveink.com http://www.interactiveink.com E-business made Easy------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Jaishankar Jayaram

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

WebCatalog Hosting (1996) Shopping carts and reloading pages (1997) [include ...] behavior (1997) minimalist shopping cart. (1997) PCS Emailer's role ? (1997) Uh...can someone help me out with the b10? (1997) RE: ShowNext Command (1997) Path of Events (1999) form to search page (2000) Mac Programs (1998) Using files in an Email broadcast (1999) WebCat2 - Getting to the browser's username/password data (1997) [OT] Am I an Idiot? (2004) did I miss anything (1997) Line Feed Character Appended (1998) Type 11 errors setting up WebCAt 2 (1997) WebCat for Unix?? (1997) [WebDNA] Webcatalog running at 100% (2016) Req: Array Tags Explained, simple and clear (2004) Million product store (2003)