Re: Flat files and ASP.NET

Yes, the OP could look into MSMQ, however what levels of traffic are we
talking here? If it isn't extremely heavy I can't understand why SQL would
be causing a bottleneck. I'd look into what is causing the delay before
looking for an alternative solution.

"Steve C. Orr [MCSD, MVP, CSM, ASP Insider]" <Steve@xxxxxxx> wrote in
message news:B7C80C83-25C3-4BF6-BE90-F75E547DC977@xxxxxxxxxxxxxxxx
I suggest you stick with a database. Flat files will almost certainly not
give you additional speed or scalability.
Perhaps you could use some sort of a queue to save up log records and only
write to the database every so often.

--
I hope this helps,
Steve C. Orr,
MCSD, MVP, CSM, ASPInsider
http://SteveOrr.net



"Navaneeth.K.N" <Navaneeth.K.N@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B93CFF77-9E87-46F3-AD4A-8F776B434424@xxxxxxxxxxxxxxxx
Hello

I am developing a system for user tracking. In this I am tracking all the
visitors that came to my website. i developed this using a HTTPModule and
storing the data in a SQL Server database. Everything worked fine till my
website gets good traffic.

When website is getting good traffic, this method is slowing down the
entire
application. So I am planning to use flat files instead of SQL Server
database. My doubts are

1 - What is a flat file and how can I connect to it from my ASP.NET
application
2 - If multiple users are browsing website at same time, how can I save
data's to file, because that may be in use.
3 - Is XML files are normal flat files ?

Please help me on this issue.

Sincerly
Navaneeth



.

Relevant Pages

  • Re: too many files....
    ... It's not until the website started ... most likely it is SQL dragging the whole thing down. ... The database queries themselves would be a good thing to ... query that retrieved all 4000 bugs in the databaseand he was ... ...
    (comp.os.linux.misc)
  • Re: Courtyard arrangement - Jeff Middleton
    ... I'm looking to set up a webserver for a public website and after ... allows us to put our products online but the database and ecommerce must ... Since you indicate SQL and WEB, you will make a rule that permits SQL ... SBS2003 SQL does not permit use of a web application without a license ...
    (microsoft.public.windows.server.sbs)
  • Re: Advice needed: Best way to deploy/manage SQL db website
    ... way to design and deploy a db-enabled website (with the ability to easily ... Server "Database Publishing Wizard" to create a SQL ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Courtyard arrangement - Jeff Middleton
    ... I'm looking to set up a webserver for a public website and after ... our business accounting applicationthat is run on SBS ... We could have an ISP host the database application AND website or we ... Since you indicate SQL and WEB, you will make a rule that permits SQL ...
    (microsoft.public.windows.server.sbs)
  • Re: Flat files and ASP.NET
    ... Flat files will almost certainly not give you additional speed or scalability. ... Perhaps you could use some sort of a queue to save up log records and only write to the database every so often. ... visitors that came to my website. ... So I am planning to use flat files instead of SQL Server ...
    (microsoft.public.dotnet.framework.aspnet)
Quantcast