Results 1 to 3 of 3

Thread: need advice about querying/export 300.000 rows

  1. #1
    Hyperactive Member RS_Arm's Avatar
    Join Date
    Mar 07
    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
    Super Moderator Hack's Avatar
    Join Date
    Aug 01
    Location
    Searching for mendhak
    Posts
    58,283

    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.
    Please use [Code]your code goes in here[/Code] tags when posting code.
    When you have received an answer to your question, please mark it as resolved using the Thread Tools menu.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    I dont answer coding questions via PM or EMail. Please post a thread in the appropriate forum section.

    Creating A Wizard In VB.NET
    Paging A Recordset
    What is wrong with using On Error Resume Next
    Good Article: Language Enhancements In Visual Basic 2010
    Upgrading VB6 Code To VB.NET
    Microsoft MVP 2005/2006/2007/2008/2009/2010/2011/2012/Defrocked

  3. #3
    Hyperactive Member RS_Arm's Avatar
    Join Date
    Mar 07
    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 09: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
  •