Archiver > GENEALOGY-DNA > 2010-03 > 1267464034

From: Wayne Kauffman <>
Subject: Re: [DNA] dbms v. spreadsheet
Date: Mon, 1 Mar 2010 09:20:34 -0800 (PST)
References: <><> <C0A1E7AC90FF49AD958DDEBC99EAED76@HP>
In-Reply-To: <C0A1E7AC90FF49AD958DDEBC99EAED76@HP>

Working with SNP results from Relative Finder or Family Finder can drag Excel to its knees if you elect to do some manipulations on the 500K+rows. I have seen Excel utilize 8 cores at 100% on my i-720 based Dell for 25+ minutes doing something I should have done in PERL or by querying a database.

- Wayne

From: Diana Gale Matthiesen <>
Sent: Mon, March 1, 2010 9:17:38 AM
Subject: [DNA] dbms v. spreadsheet

> Spreadsheets can only work with so much data - Mike Walsh has done an
> believable job with his spreadsheet, but eventually his
> spreadsheet will max out.

I haven't seen Mike Walsh's spreadsheet, so I can't comment on it. As far as
being a project admin at FTDNA, I see no project remotely reaching a size that
Excel can't handle (viz., 256 columns x 64K rows). If someone is data mining
the online DNA databases and doing research on vast quantities of data, that's
another issue. What we're talking about here is the needs of FTDNA project
To unsubscribe from the list, please send an email to with the word 'unsubscribe' without the quotes in the subject and the body of the message

This thread: