Desing Question

Hey Guys,

I have a question; it?s a design question,

I am developing an application, where in this application users upload a
database of emails in a CSV file format...now what I have done. When
they are uploading the CSV file, I read the CSV file and return a Data
Table representation of it. Then people should be able to make changes
to this Data Table before it gets saved on our actual hard drive as a
CSV file. So I created a Data Grid where I send this Data Table as data
source...but in order to do the updates, deleting and editing elements
from data grid I needed to somehow save that data table until they click
on "Accept Database", I have done that by saving it into a session. Once
"Accept Database" has been clicked. That data table gets saved into a
CSV file and it will get erased from sessions manually to ensure that it
is gone from memory

Now what worries me?

is that if I have allot of people logging in at the same time and be
doing this at the same time and each person uploading a CSV file which
usually contains minimum of 5,000 items in it, then I be saving multiple
data table with allot of elements into the session...what do you guys
think I should do ?


how can I get a way around it...what do I do with data table while its
in processing stage...where else can I save it (except sql database) to
ensure the good quality application?

thank you in advance

---
Best Regards
Amir

*** Sent via Developersdex http://www.developersdex.com ***
.

Relevant Pages

  • Re: Desing Question
    ... it's a design question, ... > they are uploading the CSV file, I read the CSV file and return a Data ... > on "Accept Database", I have done that by saving it into a session. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: transfer data into an external database
    ... >With regards to your SQL code I have no idea about SQL. ... If there is a schema.ini in the same folder as the CSV file, ... >> Create a Schema.ini file based on an existing table in your database: ... John Nurick ...
    (microsoft.public.access.externaldata)
  • Re: Pre-set Query Conditions that cannot be changed
    ... to a CSV file and then convert that CSV file in Word to a table, ... that 'Query Options have been set', but trying to change them reveals ... at a time into a blank database. ... methods required re-defintion of fields and reports. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Exporting table to .csv file, then importing .csv file back to
    ... "John Nurick" wrote: ... Option Database ... Public Sub ReImportFromTheCSVFile() ... I have used the wizard within MS Access 2000 to export to a csv file, ...
    (microsoft.public.access.externaldata)
  • Re: PHP/MySQL project
    ... > Looking to build a dynamic site using PHP/MySQL. ... > import changes to the database easily. ... Import the csv file into the MySql db, and then use phpmyadmin in the future ... The version of PHP will be important if you are considering finding / buying ...
    (alt.php)