Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Classic ASP XML Using ASP 3 and XML. See also the XML category for more XML discussions not relating to ASP. NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP XML section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 2nd, 2004, 06:42 AM
ak ak is offline
Authorized User
 
Join Date: Sep 2003
Location: London, , United Kingdom.
Posts: 37
Thanks: 0
Thanked 0 Times in 0 Posts
Default efficiency qn - writing and saving xml file

Hi,
need some advise on the best approach to take and also if any one knows of a any resouce on this subject that exists online?

When a banner displays on my site, the banner display count is recorded in an xml file and the xml file is saved each time

follwing error occures occasionally:
msxml3.dll error '80070020'
The process cannot access the file because it is being used by another process.
/globalincludes/incBanner.inc, line 291


my questions:
[1] is it better to use a sql server database then xml for recording such data? e.g banner display count could amount to as much as 10000 in a day.

[2] This continuous and frequent saving of the xml file due to client activity - am i using xml for an inappropriate purpose? I had initially done this to reduce the hits on our sql server.

looking forward any valuable replies.







ak
__________________
ak
 
Old March 2nd, 2004, 05:26 PM
planoie's Avatar
Friend of Wrox
Points: 16,481, Level: 55
Points: 16,481, Level: 55 Points: 16,481, Level: 55 Points: 16,481, Level: 55
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2003
Location: Clifton Park, New York, USA.
Posts: 5,407
Thanks: 0
Thanked 16 Times in 16 Posts
Default

See this thread for the answer.




Similar Threads
Thread Thread Starter Forum Replies Last Post
writing into xml file jerryjohn XML 1 August 18th, 2006 02:40 AM
writing to am xml file MOU Classic ASP XML 0 July 6th, 2005 07:38 AM
Reading from a xml file and writing to another billy_bob_the_3rd XML 5 April 29th, 2005 01:40 PM
efficiency qn xml vs sql server - to record counts ak Classic ASP Databases 3 March 3rd, 2004 05:26 PM
efficiency qn:ado .AddNew VS INSERT in stored proc ak Classic ASP Databases 1 February 25th, 2004 10:08 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.