• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Need advice: handling SQL DB based datasource for NSTableView
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Need advice: handling SQL DB based datasource for NSTableView


  • Subject: Re: Need advice: handling SQL DB based datasource for NSTableView
  • From: Mark Satterfield <email@hidden>
  • Date: Thu, 27 Mar 2003 12:07:43 -0700

I'm using multiple table views all being fed data from a SQLite database. What I found is that making a db call for each callback works fine except for one exception and that is the call to 'numberOfRowsInTableView'. Don't make a call to your db here, especially if it's a large table, because your view will coming to a grinding halt.

mark


On Thursday, March 27, 2003, at 10:32 AM, Guy Umbright wrote:

I have an NSTableView that is fed (via its datasource) the
contents of an SQLite table. The two approaches I see to
handle this are:

1) Make a db call each time the datasource callback is invoked

2) Keep a 'snapshot' of the table in memory (refreshed as needed)
and use it to provide the data

Of course there are some options sort of in the middle of those
as well. From experience, what have others found to be the best
approach to follow?
_______________________________________________
cocoa-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/cocoa-dev
Do not post admin requests to the list. They will be ignored.

  • Prev by Date: Re: Using NSTimer to call the main thread
  • Next by Date: Re: Japanese name for FileMaker
  • Previous by thread: Re: Need advice: handling SQL DB based datasource for NSTableView
  • Next by thread: Size of a bundle (or directory)
  • Index(es):
    • Date
    • Thread