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 23Fax: (614) 221-7098mailto:jai@interactiveink.comhttp://www.interactiveink.comE-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:
|
- 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 23Fax: (614) 221-7098mailto:jai@interactiveink.comhttp://www.interactiveink.comE-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:
RequiredFields template (1997)
New public beta available (1997)
wierd [cart] action! (1997)
OPEN MARKET PATENTS SOUND ECOMMERCE ALARM (1998)
caching -check- (2001)
A quickie question (1997)
Ok here is a question? (1997)
Separate SSL Server (1997)
OK, here goes... (1997)
WebCommerce: Folder organization ? (1997)
Running WebCat from a CD-ROM (1997)
Re:Emailer and encryption (1997)
Error Messages Returned to User (1997)
[WebDNA] need decoded url in sendmail (2015)
Location of Browser Info.txt file (1997)
[WebDNA] Problem with administration (2009)
how to get first some letters of a variable (2000)
re:check boxes (1997)
Progress !! WAS: Trouble with formula.db (1997)
syntax question, not in online refernce (1997)