Re: Hacker's Fate

FROM : Tito Ciuro
DATE : Mon Jan 20 16:11:31 2003

On Friday, January 17, 2003, at 12:02  PM, zauhar wrote:

>> Simply put, has anyone got a working app that displays, say, 1,000,000
>> rows through a table view with reasonable performance? I want to
>> implement an application that can do that.


Yes, I have: using SQLite (http://www.hwaci.com/sw/sqlite) and Cocoa.

Performance? It's pretty darn fast even with 1,000,000 records.

> 2) NSTableView is quite scalable. The long and short of it is that the
> ONLY bottleneck is how you implement your NSTableDataSource object.
> Here is an example I posted, with extremely alpha quality code mind
> you, that shows how to use NSTableView with millions of rows.
>
> http://www.mindlube.com/download/files/Tabularity%200.1.dmg
>
> Now some will say this proves nothing, because it's not a stable app or
> it's not finished, or it's sloppily coded or whatever. But that's
> totally evading the point. The point is very simple. Be smart in
> implementing your NSTableDataSource.


Since Tabularity requires BDB, I created an app with the SQLite engine
included, so there's no need to download and install anything else.

If you want to try it, you can download it here:
http://homepage.mac.com/tciuro

It uses the NSTableView we all love, nothing more, nothing less. If you
decide to try with 1,000,000 records, I *strongly* suggest that you
don't index the table, because it'll take way too much. You've been
warned!

The NSTableView data source is the database itself, and the data is not
loaded in an array. Since SQLite is pretty fast getting the data, it
fetches it directly. With 1,000,000 records, you'll sure hear the disk
drive when you scroll though! :)

> The point is very simple. Be smart in implementing your
> NSTableDataSource.


I couldn't agree more.

Regards,

-- Tito
_______________________________________________
cocoa-dev mailing list | <email_removed>
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/cocoa-dev
Do not post admin requests to the list. They will be ignored.