Re: Reading large csv-file and removing duplicates

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


I tried to import the data in a Ms Access 2007 database, but the file is to
large :-))

Robertico.

Use NTFS and MySQL (still free? dont know), rember a ISAM text (or
blob) filled only db will need to be configured a bit, the value of
myisam_data_pointer_size can be from 2 to 7. A value of 4 allows
tables up to 4GB; a value of 6 allows tables up to 256TB. MS Access
might work for your private CD/DVD collection, but not for handling
more data.

There should be a number of C# examples for reading/writing the
database out there.

//CY

.

Relevant Pages

  • limiting returned amount of rows
    ... I use ADO to read data from _any_ database; ... basically I dont know what is in the other end :-) ... then how do I do it with Interbase and MySQL? ...
    (borland.public.delphi.database.ado)
  • Re: MySQL Database problem (probably already solved in a message, but this is somewhat urgent)
    ... MySQL server has a database with a table, ... columns, an FSR column, and a password column. ... checked if the supposed arrays that were returned were actually arrays ...
    (comp.lang.php)
  • RE: FreeBSD 5.3 MySQL Performance
    ... versions of Linux and FreeBSD for most tests. ... > popular with the ATA disk drive manufacturers. ... > Many companies have used FreeBSD and MySQL for years and years. ... it is not often that you have such a small database and such a large ...
    (freebsd-questions)
  • ANN: Database Designer for MySQL version 1.6 is released
    ... The new version 1.6 of MicroOLAP Database Designer for MySQL has been ... The secure shell (SSH) tunneling is now implemented in Database ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: toolkits or APIs to create a web interface as a frontend to mysql
    ... I am also *not* looking for a web based full fledged mysql client. ... For simple display of tabulated data the most useful thing is a displaywhich uses 's with absolute coordinates to position text in a box of defined width, formatted to be left, right or center justified, an using a preselected style from a a style sheet. ... As far as the actual database calls go, those are specific to each form, and apart from a little coding so that 'database_open, database_close' exist in the library, taking such things as the database name, user name and password from an included file I find it easiest to simply do the query and iterate through it to display the data requested. ...
    (comp.os.linux.misc)