software needed 
Author Message
 software needed

Hello,

I'm trying to find database software that can handle 250,000 to 500,000
records, 10 fields each, all text.

I really don't want to chunk up the database into 5+ separate pieces.

Right now, the ones I've tried will clog at 60,000 records (Instabase,
Access, Maximizer).  My spreadsheet (Corel Quattro) also balks at these
numbers, but a spreadsheet that handled 250,000 records would do as well
as a database program.

Capabilities needed:
    - searchable and sortable by multiple fields, for instance "Find all
Country=NZ, and sort by city", or "find all country=US and sort by
state, then sort by city"
    - Results of searches can be saved as .csv files.
    - Ability to import files of data to existing database, not having
to start another.  For instance, if I have 10,000 more records to add, I
don't have to add individually!
    - Really, that's all I need.  No special font, image, hyperlink, or
any other capability.  Just handling text.

Something tells me my needs will be better met by simpler software,
developed in years past.  Less ram used, less data stored per field,
because it's just text.

My system is 700Mhz, 128M ram.

I am not a corporation, and don't have big cash to spend.

Thanks so much for your help!


Don

--
At your service,
Frances Schagen & Don Waechter
---------------------------------------------------------------------------------------

Fran Schagen Bookkeeping and Business Consulting
1-902-678-1607 business line (fax-capable)
1-253-390-3432 eFax (fax to email from regular fax machine)
---------------------------------------------------------------------------------------



Sun, 24 Aug 2003 21:11:25 GMT
 software needed

Hi Don and Frances -

FMPro is certainly capable of handling your scenario, and it has a short learning curve
that would get you up and running quickly.  Importing, exporting, searching and sorting are
all strengths of FMPro.  Also, it's relatively inexpensive.

If you want to absolutely maximize performance, you might get a copy of Paradox or FoxPro
for DOS, from the mid-Nineties.  On today's hardware, these packages offer truly awesome
speed.  The Rushmore version of Paradox can sort a database of the size you describe in
less than a second on a 500MHz machine.  However, they are far more awkward to learn and
use.  I think you will be happy with FMPro, now and for your future needs.

Best of Luck -
James


Quote:
> Hello,

> I'm trying to find database software that can handle 250,000 to 500,000
> records, 10 fields each, all text.

> I really don't want to chunk up the database into 5+ separate pieces.

> Right now, the ones I've tried will clog at 60,000 records (Instabase,
> Access, Maximizer).  My spreadsheet (Corel Quattro) also balks at these
> numbers, but a spreadsheet that handled 250,000 records would do as well
> as a database program.

> Capabilities needed:
>     - searchable and sortable by multiple fields, for instance "Find all
> Country=NZ, and sort by city", or "find all country=US and sort by
> state, then sort by city"
>     - Results of searches can be saved as .csv files.
>     - Ability to import files of data to existing database, not having
> to start another.  For instance, if I have 10,000 more records to add, I
> don't have to add individually!
>     - Really, that's all I need.  No special font, image, hyperlink, or
> any other capability.  Just handling text.

> Something tells me my needs will be better met by simpler software,
> developed in years past.  Less ram used, less data stored per field,
> because it's just text.

> My system is 700Mhz, 128M ram.

> I am not a corporation, and don't have big cash to spend.

> Thanks so much for your help!


> Don

> --
> At your service,
> Frances Schagen & Don Waechter
> ---------------------------------------------------------------------------------------

> Fran Schagen Bookkeeping and Business Consulting
> 1-902-678-1607 business line (fax-capable)
> 1-253-390-3432 eFax (fax to email from regular fax machine)
> ---------------------------------------------------------------------------------------

--
Don't forget to remove the obvious spam block when replying.
I advocate making an address book entry and using it!  Thanks!


Mon, 25 Aug 2003 01:23:39 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. desktop software needed with SS?

2. software needed

3. Software needed

4. Software Needed to Connect to SQL Server Database??

5. Clients software needed to access MS SQL Server?

6. Replication Solution/Software Needed!!!

7. OCP STS software needed

8. Stress Test software needed

9. software needed

10. Sun Cluster software needed for OPS ?

11. sybase rep..across platform ..software needed ??

12. Soundex Software needed


 
Powered by phpBB® Forum Software