Home > Archive > SQL Anywhere Feedback > June 2005 > ISQL should handle massive result sets with grace and aplomb









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author ISQL should handle massive result sets with grace and aplomb
Breck Carter

2005-06-02, 1:23 pm

Even laptops have lots of RAM these days: 1G or 2G is not
uncommon, and the amounts will only grow.

Tables like satmp_request_time also grow rapidly, as busy
servers produce multi-gigabyte request level log files.

Put the two together, and it's not uncommon to want to
quickly browse through tens or hundreds of thousands of rows
in a GUI, and ISQL is that GUI.

ISQL should handle massive result sets with grace and
aplomb. If there isn't enough RAM, it should offer the
option of "windowing" the result set; i.e., disposing of
earlier rows to make room for later rows as scrolling
proceeds. If it doesn't "window" in reverse, that's OK... I
really just want to be able to look at the whole thing at
least once.

Breck
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com