Re: Desing Question

"Amir Ghezelbash" <amir-20@xxxxxxxxxx> wrote in message
news:uYCVWGzdFHA.3012@xxxxxxxxxxxxxxxxxxxxxxx
> 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 ?
>

Can you save the working data into a temp table?





.

Relevant Pages

  • Desing Question
    ... I have a 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: Problem in displaying message while uploading file.
    ... I'm developing an application in which i'm parsing a csv file and ... uploading into a database. ... while uploading i can not show any message box. ...
    (comp.lang.java.gui)
  • 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: 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)