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!

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

2000

Top Articles:

Related Readings: