Results 1 to 3 of 3

Thread: need advice about querying/export 300.000 rows

  1. #1

    Thread Starter
    Hyperactive Member RS_Arm's Avatar
    Join Date
    Mar 2007
    Location
    Planet Earth
    Posts
    282

    need advice about querying/export 300.000 rows

    Hello guys
    I need to export bill/receipt from my database to text files/xml.
    My database has about 300.000 lines for bill/receipts.
    Should I export all lines in one single processing, or should I export one bill by one?

    My database is based on Access2 and I'm doing this with VB6.

    Thank you in advance for your advice.

  2. #2
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: need advice about querying/export 300.000 rows

    After the export, what will be done?

    Will the bills be mailed to customers? If so, then one by one would be the way to go.

  3. #3

    Thread Starter
    Hyperactive Member RS_Arm's Avatar
    Join Date
    Mar 2007
    Location
    Planet Earth
    Posts
    282

    Re: need advice about querying/export 300.000 rows

    Each bill will have one file per department.
    Those files are needed due to integration matters.
    What worries me more is how the server will handle and manage such amount of data.
    This operation doesn't need to very quick, (kinda 5/10m), it can be processed over 2 or 3 hours.
    What I need is to optimize the querys, so that the server will not be overloaded of data and get stuck.
    Last edited by RS_Arm; Nov 19th, 2007 at 10:44 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width