Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
ASP.NET 2.0 Professional If you are an experienced ASP.NET programmer, this is the forum for your 2.0 questions. Please also see the Visual Web Developer 2005 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Professional 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 October 25th, 2007, 05:38 PM
Friend of Wrox
 
Join Date: Mar 2006
Location: , , Portugal.
Posts: 310
Thanks: 0
Thanked 0 Times in 0 Posts
Default save pollVotes into xml

I need to make an important decision about this:

In my new webForum, I will have polls.

If I save the pollVotes in DB I'll have a thousand of rows(votes) in a few days!

Suppose, if I have 40 polls and 300 users I'll have:
300x40 = 1200 rows

My table is: (PollID int, MemberName nvarchar(256), PollChoice int)

In a couple of weeks/months I'll have my database size INCREASE!

I'm wondering:
Save this votes into a xml file is a good choice? Is it fast?
I never worked with xml. I don't want to know how can I do it but I need to know the philosophy.
I can save a xml for each poll.
I only need to know If I can add more nodes into an xml file without
need to take all nodes into aspnet, add one more and then resave all nodes.


second question:
When a user come to a pollThread he need to now how mani users voted in choice1, choice2, ...
Can I count fast the nodes who have attribute("choice=1"), attribute("choice=2"), attribute("choice=3"), etc...

I'll appreciate any comments about this idea!
Thanks





Similar Threads
Thread Thread Starter Forum Replies Last Post
Save database schema to XML file brettk_1 General .NET 2 September 16th, 2006 04:27 AM
save word formfields into an xml file manjugv Word VBA 0 May 1st, 2006 04:44 PM
Can't save XMLDoc to a xml file using JScript induriprakash Javascript 2 May 13th, 2005 02:44 PM
error using XML save method Heroic Dose XML 1 November 13th, 2003 01:24 PM
error using XML save method in javascript Heroic Dose Javascript 3 September 22nd, 2003 08:05 AM





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