Home » Eclipse Projects » Standard Widget Toolkit (SWT) » SWT or KTable for large worksheets and streaming data
| SWT or KTable for large worksheets and streaming data [message #464109] |
Thu, 17 November 2005 01:48  |
 Mark Proctor
Messages: 18
Registered: July 2009 |
Junior Member |
|
|
I'm looking at a worksheet application with the following characteristics:
-Target platform win32 only
-Wide columns, 20-50 columns
-Typically 3-6K of cells, could be up to 9K
-Frozen/fixed left column for row names
-Row and Column highlights turned on by user
-Cell Shading
-Cell blinking, based on an expression which may compare values against
other cells
-Streaming of data; with anything from 2 to 200 updates a second
-Embedding of tick boxes and combo boxes
-dynamic filtering and sorting, as data is streamed
-Typically 4-6 windows, each window can have 4-8 worksheets but only one
visible worksheet per window - all worksheets can be of the sizes
mentioned above.
-If possible using Glazed Lists as a standard API for data streaming,
sorting and filtering. However only SWT table is supported, not KTable :(
Because of my desire to use GlazedLists I'm hoping that SWT is
performant enough, is it?
While KTable supports frozen columns I'm hoping I can support this with
SWT in the same manner that JTable does, two views on the same model.
Left view only displays a single column, no visible scroll bars, but
with its vertical scroll position linked to the main views vertical
scroll position.
Thanks
Mark
|
|
|
| Re: SWT or KTable for large worksheets and streaming data [message #464111 is a reply to message #464109] |
Thu, 17 November 2005 02:27  |
Mark Proctor
Messages: 18
Registered: July 2009 |
Junior Member |
|
|
My initial tests show that SWT Table can handle large numbe rows but
repainting when scrolling on 50 columns is slow - fast vertical
scrolling, slow horizontal scrolling. So looks like I have to use
KTable, has anyone here attempted to write a GlazedList implementation
for KTable? Is KTable as performant as JTable for large worksheets?
Mark
Mark Proctor wrote:
> I'm looking at a worksheet application with the following characteristics:
> -Target platform win32 only
> -Wide columns, 20-50 columns
> -Typically 3-6K of cells, could be up to 9K
> -Frozen/fixed left column for row names
> -Row and Column highlights turned on by user
> -Cell Shading
> -Cell blinking, based on an expression which may compare values against
> other cells
> -Streaming of data; with anything from 2 to 200 updates a second
> -Embedding of tick boxes and combo boxes
> -dynamic filtering and sorting, as data is streamed
> -Typically 4-6 windows, each window can have 4-8 worksheets but only one
> visible worksheet per window - all worksheets can be of the sizes
> mentioned above.
> -If possible using Glazed Lists as a standard API for data streaming,
> sorting and filtering. However only SWT table is supported, not KTable :(
>
> Because of my desire to use GlazedLists I'm hoping that SWT is
> performant enough, is it?
>
> While KTable supports frozen columns I'm hoping I can support this with
> SWT in the same manner that JTable does, two views on the same model.
> Left view only displays a single column, no visible scroll bars, but
> with its vertical scroll position linked to the main views vertical
> scroll position.
>
> Thanks
>
> Mark
|
|
|
| Re: SWT or KTable for large worksheets and streaming data [message #464153 is a reply to message #464111] |
Thu, 17 November 2005 03:08 |
Mark Proctor
Messages: 18
Registered: July 2009 |
Junior Member |
|
|
Opened a bugzilla for this, just in case its interesting to anyone.
https://bugs.eclipse.org/bugs/show_bug.cgi?id=116776
Mark Proctor wrote:
> My initial tests show that SWT Table can handle large numbe rows but
> repainting when scrolling on 50 columns is slow - fast vertical
> scrolling, slow horizontal scrolling. So looks like I have to use
> KTable, has anyone here attempted to write a GlazedList implementation
> for KTable? Is KTable as performant as JTable for large worksheets?
>
> Mark
> Mark Proctor wrote:
>> I'm looking at a worksheet application with the following
>> characteristics:
>> -Target platform win32 only
>> -Wide columns, 20-50 columns
>> -Typically 3-6K of cells, could be up to 9K
>> -Frozen/fixed left column for row names
>> -Row and Column highlights turned on by user
>> -Cell Shading
>> -Cell blinking, based on an expression which may compare values
>> against other cells
>> -Streaming of data; with anything from 2 to 200 updates a second
>> -Embedding of tick boxes and combo boxes
>> -dynamic filtering and sorting, as data is streamed
>> -Typically 4-6 windows, each window can have 4-8 worksheets but only
>> one visible worksheet per window - all worksheets can be of the sizes
>> mentioned above.
>> -If possible using Glazed Lists as a standard API for data streaming,
>> sorting and filtering. However only SWT table is supported, not KTable :(
>>
>> Because of my desire to use GlazedLists I'm hoping that SWT is
>> performant enough, is it?
>>
>> While KTable supports frozen columns I'm hoping I can support this
>> with SWT in the same manner that JTable does, two views on the same
>> model. Left view only displays a single column, no visible scroll
>> bars, but with its vertical scroll position linked to the main views
>> vertical scroll position.
>>
>> Thanks
>>
>> Mark
|
|
|
| Re: SWT or KTable for large worksheets and streaming data [message #464157 is a reply to message #464153] |
Thu, 17 November 2005 08:43 |
Eclipse User |
|
|
|
Originally posted by: friederich.kupzog.de
Hi Mark,
what is a "GalzedList"?
Regards,
Friederich
Mark Proctor wrote:
> Opened a bugzilla for this, just in case its interesting to anyone.
> https://bugs.eclipse.org/bugs/show_bug.cgi?id=116776
> Mark Proctor wrote:
>
>> My initial tests show that SWT Table can handle large numbe rows but
>> repainting when scrolling on 50 columns is slow - fast vertical
>> scrolling, slow horizontal scrolling. So looks like I have to use
>> KTable, has anyone here attempted to write a GlazedList implementation
>> for KTable? Is KTable as performant as JTable for large worksheets?
>>
>> Mark
>> Mark Proctor wrote:
>>
>>> I'm looking at a worksheet application with the following
>>> characteristics:
>>> -Target platform win32 only
>>> -Wide columns, 20-50 columns
>>> -Typically 3-6K of cells, could be up to 9K
>>> -Frozen/fixed left column for row names
>>> -Row and Column highlights turned on by user
>>> -Cell Shading
>>> -Cell blinking, based on an expression which may compare values
>>> against other cells
>>> -Streaming of data; with anything from 2 to 200 updates a second
>>> -Embedding of tick boxes and combo boxes
>>> -dynamic filtering and sorting, as data is streamed
>>> -Typically 4-6 windows, each window can have 4-8 worksheets but only
>>> one visible worksheet per window - all worksheets can be of the sizes
>>> mentioned above.
>>> -If possible using Glazed Lists as a standard API for data streaming,
>>> sorting and filtering. However only SWT table is supported, not
>>> KTable :(
>>>
>>> Because of my desire to use GlazedLists I'm hoping that SWT is
>>> performant enough, is it?
>>>
>>> While KTable supports frozen columns I'm hoping I can support this
>>> with SWT in the same manner that JTable does, two views on the same
>>> model. Left view only displays a single column, no visible scroll
>>> bars, but with its vertical scroll position linked to the main views
>>> vertical scroll position.
>>>
>>> Thanks
>>>
>>> Mark
--
Friederich Kupzog
Elektronik & Software
Neusser Str. 5-7
50670 Köln
Tel 0241 160696-1
Fax 0221 726670
www.kupzog.de/fkmk
|
|
|
| Re: SWT or KTable for large worksheets and streaming data [message #464160 is a reply to message #464157] |
Thu, 17 November 2005 14:21 |
Mark Proctor
Messages: 18
Registered: July 2009 |
Junior Member |
|
|
KTable speed works like a dream, so SWT Tables is out of here.
Glazed lists, http://publicobject.com/glazedlists/, is probably as near
as you will come to a standard api for data streaming, filtering and
sorting; its pretty advanced with chained transformations - even get's
Hani's vote of confidence from the BileBlog. I've opened a feature
request for this:
http://sourceforge.net/tracker/index.php?func=detail&aid =1358680&group_id=114292&atid=667841
I think Glazed Lists support will go a long way in helping to build
adoption and allowing people to more easily build complex apps. FYI I'm
looking at building a Worksheet application for traders.
I've patched KTable to expose double click,
http://sourceforge.net/tracker/index.php?func=detail&aid =1358719&group_id=114292&atid=667841,
this is for sorting on column double clicks, I don't think we want to
enforce on the user the mouse interactions. This could be taken further
with mouse interactions in general - might be worth making the
operations of each configuration via default decorators that can be
changed by the user.
I've also added a request for draggeable Columns:
http://sourceforge.net/tracker/index.php?func=detail&aid =1358701&group_id=114292&atid=667841
Finally I'm looking at the best way of doing the following:
-Row/Column highlighting. User will want to turn on higlighting (single
click) and optionally specify a colour, on or more rows/columns.
-Cell Highlighting. Cells can also be highlighted in a similar manner.
-Cell Flashing/Blinking. Cells can be set to flash/blink, possible as
the result of a boolean expression turning this on and off.
My current approach to this is to create a CellStyle[][] instance to my
model - with methods on my model for highlightRow, highlightColumn and
flashColumn. By default all elements are null, unless I want to set the
style on a cell in which case it creates and assigns a CellStyle with fg
and bg colours. When it requests the renderer, if that cell has a
CellStyle, I set the bg and fg for this. Is this a good approach?
Finally when does KTable redraw the visible screen, is it enough for me
to simply set the CellStyle and redrawing happens X times a second and
my actions take effect - or will I have to call redraw at regular
intervals for my bg/fg colors to become visible?
Thanks
Mark
Friederich Kupzog wrote:
> Hi Mark,
>
> what is a "GalzedList"?
>
> Regards,
> Friederich
>
> Mark Proctor wrote:
>> Opened a bugzilla for this, just in case its interesting to anyone.
>> https://bugs.eclipse.org/bugs/show_bug.cgi?id=116776
>> Mark Proctor wrote:
>>
>>> My initial tests show that SWT Table can handle large numbe rows but
>>> repainting when scrolling on 50 columns is slow - fast vertical
>>> scrolling, slow horizontal scrolling. So looks like I have to use
>>> KTable, has anyone here attempted to write a GlazedList
>>> implementation for KTable? Is KTable as performant as JTable for
>>> large worksheets?
>>>
>>> Mark
>>> Mark Proctor wrote:
>>>
>>>> I'm looking at a worksheet application with the following
>>>> characteristics:
>>>> -Target platform win32 only
>>>> -Wide columns, 20-50 columns
>>>> -Typically 3-6K of cells, could be up to 9K
>>>> -Frozen/fixed left column for row names
>>>> -Row and Column highlights turned on by user
>>>> -Cell Shading
>>>> -Cell blinking, based on an expression which may compare values
>>>> against other cells
>>>> -Streaming of data; with anything from 2 to 200 updates a second
>>>> -Embedding of tick boxes and combo boxes
>>>> -dynamic filtering and sorting, as data is streamed
>>>> -Typically 4-6 windows, each window can have 4-8 worksheets but only
>>>> one visible worksheet per window - all worksheets can be of the
>>>> sizes mentioned above.
>>>> -If possible using Glazed Lists as a standard API for data
>>>> streaming, sorting and filtering. However only SWT table is
>>>> supported, not KTable :(
>>>>
>>>> Because of my desire to use GlazedLists I'm hoping that SWT is
>>>> performant enough, is it?
>>>>
>>>> While KTable supports frozen columns I'm hoping I can support this
>>>> with SWT in the same manner that JTable does, two views on the same
>>>> model. Left view only displays a single column, no visible scroll
>>>> bars, but with its vertical scroll position linked to the main views
>>>> vertical scroll position.
>>>>
>>>> Thanks
>>>>
>>>> Mark
>
>
|
|
|
Goto Forum:
Current Time: Thu Apr 18 19:32:00 GMT 2024
Powered by FUDForum. Page generated in 0.02247 seconds |
] 
Search
Help
Register
Login
Home
