So I have some code that logs page information on every page and across
multiple servers...
The idea is to slap the data into Access and fold a database file a day
vs. the overhead and in box disk issues with SQL Server.. not to
mention cost...
Scenario....
2 users access a page... one on SERVER A the other on SERVER B...
Same code .. same database (Access) in both and stored on a NAS storage
device...
Both folks go to the page at the same time...
<cfquery name="logactivity" datasource="logger">
update dailyimpressions
where record = #record#
</cfquery>
Now that work across a few million pages a month, but generate a few -
50-100 errors a day of :
ODBC Error Code = S1000 (General error)
[Microsoft][ODBC Microsoft Access Driver] Could not update; currently
locked by user 'adm' on machine 'CRAPO1'.
SQL = "insert into dailyimpressions.... ETC.
WHat would any of you recommend to lock the database call /reduce
errors spun out?
Interested in hearing everyone's input... Locks.. ehh...
-paris
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
