|
From: Robert M. <rob...@gm...> - 2010-06-03 16:22:52
|
I don't know if anyone else feels this way, but bringing back the entire contents of the database and browsing them to find what you are looking for doesn't seem very helpful or even efficient. SQuirreL does provide the ability to limit the results so that a user can browse a subset of all of the data when they have no idea what they are looking for. That mechanism seems to work pretty well at limiting the RAM footprint. Rob On 6/2/10, bcarle1 <bca...@dr...> wrote: > > Hi all, > > I recently switched from the Sql Server Client application to the Squirrel > Client. And while I think Squirrel is a very good multi-lingual sql > graphical client, I do have some issues with how Squirrel handles memory. > > Why on earth does squirrel keep all the results of a query in RAM? In a > production environment where you might run a query with results of a Gig or > more, this really eats up your computer's memory fast. Why doesn't Squirrel > write those results to disk and then only pull them if they are being > viewed. This is how Microsoft's Sql Client works and is able to run a query > with 2 GB of results, yet only take up less than 300 MB of RAM. It writes > it all to disk until the user tries to view it. > > I don't know if this is in the pipeline for you fellows or not, but it > should be. > > Any comments? > -- > View this message in context: http://old.nabble.com/When-will-Squirrel-Memory-Issues-be-Addressed--tp28759538p28759538.html > Sent from the squirrel-sql-develop mailing list archive at Nabble.com. > > > ------------------------------------------------------------------------------ > ThinkGeek and WIRED's GeekDad team up for the Ultimate > GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the > lucky parental unit. See the prize list and enter to win: > http://p.sf.net/sfu/thinkgeek-promo > _______________________________________________ > Squirrel-sql-develop mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop > |
