[dba-SQLServer]

Billy Pang tuxedo_man at hotmail.com
Tue Oct 14 13:49:14 CDT 2003


IIS records everything in that table.  I imgaine on a heavy traffic day 
there will be millions records insert into it that day alone.  I only care 
about maybe a hand full of records in that table.

Billy

>From: "Eric Barro" <ebarro at afsweb.com>
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: <dba-sqlserver at databaseadvisors.com>
>Subject: RE: [dba-SQLServer]
>Date: Tue, 14 Oct 2003 10:53:16 -0700
>
>Billy,
>
>What's the purpose of exporting those records? If it's for statistical 
>purposes why not just run queries on the table?
>
>---
>Eric Barro
>Senior Systems Analyst
>Advanced Field Services
>(208) 772-7060
>http://www.afsweb.com
>
>-----Original Message-----
>From: dba-sqlserver-bounces at databaseadvisors.com
>[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of Billy
>Pang
>Sent: Tuesday, October 14, 2003 10:47 AM
>To: dba-SQLServer at databaseadvisors.com
>Subject: [dba-SQLServer]
>
>
>Hello:
>
>Our IIS Server is logging website hits to SQL Server.  We are trying to
>figure out best way to export certain records from this table into another
>table every 5 minutes.  So far, we came up with two options:
>
>1) in a separate table, store the ID of the last record in the IIS Log 
>table
>that was exported.  Every 5 minutes, export the records that are greater
>than the last exported ID.
>
>2) pick one of the columns in the log table to be the "Exported" flag
>column.  After exporting a record from the log table, update that record as
>exported.
>
>We are leaning towards #2 but am unsure about any locking issues.  AKAIK,
>IIS only inserts records into that table, never update.
>
>Any ideas or thoughts?
>
>Thanks in advance,
>Billy
>
>_________________________________________________________________
>The new MSN 8: advanced junk mail protection and 2 months FREE*
>http://join.msn.com/?page=features/junkmail
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.525 / Virus Database: 322 - Release Date: 10/9/2003
>
>---
>Outgoing mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.525 / Virus Database: 322 - Release Date: 10/9/2003
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>

_________________________________________________________________
Tired of spam? Get advanced junk mail protection with MSN 8.  
http://join.msn.com/?page=features/junkmail



More information about the dba-SQLServer mailing list