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.
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.