[dba-SQLServer] 2-minute window

Also interesting. I will give this approach a test as well. Thanks, Billy!

Billy Pang wrote:

> how about a new table that stores the temporary grabs.  in that table 
> is a column called "expire_datetime".  when that table is populated, 
> the "expire_datetime" is set to 2 minutes into the future.  A sql 
> server agent that runs every two minutes can remove records that have 
> expired.
>
>
>
>> From: Arthur Fuller <artful at rogers.com>
>> Reply-To: dba-sqlserver at databaseadvisors.com
>> To: dba-sqlserver at databaseadvisors.com
>> Subject: [dba-SQLServer] 2-minute window
>> Date: Wed, 08 Dec 2004 17:57:01 -0500
>>
>> I have to create a situation in which the customer (web) selects an 
>> item and I want to put a 2-minute limit on the grab, so if the user 
>> fails to click Submit within two minutes the grab is cancelled.
>>
>> I really have no idea how to implement this. In keeping with my 
>> general predilections, then I would much prefer that it occur in the 
>> db not in the front end, not least because in this app there will be 
>> both an Access FE and a web FE, so I would like both to fire a sproc 
>> or something to effect this 2-minute window.
>>
>> Maybe I could write the grabs to a new table, but I would need to 
>> observe that in the real table the quantity is 10 and in the temp 
>> table 4 grabs are currently active, i.e. there are only 2 items 
>> remaining... which could change if the 2-minute window expires or the 
>> user clicks Cancel.
>>
>> I'm quite unsure how to go about this. Any advice? As stated above, I 
>> would much prefer to do it in the BE than the FEs.
>>
>> Arthur
>>
>>>
>>
>>
>> -- 
>> No virus found in this outgoing message.
>> Checked by AVG Anti-Virus.
>> Version: 7.0.289 / Virus Database: 265.4.7 - Release Date: 12/7/2004
>>
>> _______________________________________________
>> dba-SQLServer mailing list
>> dba-SQLServer at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>> http://www.databaseadvisors.com
>>
>
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>
>


-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.289 / Virus Database: 265.4.7 - Release Date: 12/7/2004