Re: Importing A Lot Of Data

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Nanette wrote:
I'm creating a database to track inventory. We receive a weekly report that needs to be kept and compared to the previous week and/or weeks.

I'm concerned about the amount of data that could be imported into the database.

Any suggestions?

You could try simulating the amount of data you might have and see where it leaves you.

For what it's worth, I have a database with some 4 million records, 8 columns (mostly numeric) and it's just fine. (Takes forever to compact, but that's another story...)

--
Smartin
.

Relevant Pages

  • Re: Audacity and Gentoo
    ... >> Oracle Black Helicopter Base in Antarctica: ... they're not both going to be wrong by the same amount as ... There's over 5,000 games in that 15 ... TBH I doubt I'll ever migrate this system from a database to direct ...
    (uk.comp.os.linux)
  • Re: My Enterprise Architecture - your thoughts?
    ... > the technology is less important than the architecture - sufficient to ... This is not reasonable for reports. ... > As you can see there is a fair amount of mapping/transforming. ... Your relational database is going to be the single most ...
    (comp.object)
  • Re: Summing based on various critiera
    ... I know full well what a flat file is and I know what a database ... database arrangement. ... it has been the same amount of monies for everyone. ... one amount for adults and one amount for kids. ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Lord Help Me Project
    ... I’ve successfully recreated this into a relational database with the ... Requirement - $ amount the office says is required perform a certain ... $ amount that usually matches Val Rqmt, ... I really only need the date field to capture the year, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Estimate space freed up by compacting MS Access
    ... MS-Access database (without actually doing the compact)? ... My reason for asking is that we have an application that uses an access ... compact it when the amount of reclaimable space goes over 30%. ...
    (borland.public.delphi.database.ado)