RTD server performance

[B Deepak]

Hi Grp,

I have to excel sheets which has 10 cells each. and I have to develop a
RTDServer using vb.net. Now I am assigning all my cells wich the RTDServer
formula which I is to be developed. Now can anybody suggest me will this
RTDServer face performance issue due to coninuous updates for 20 cells?

Thanks,
Deepak

[John.Greenan]

Without knowing exactly what you are doing it's not possible to answer, but I
run an RTD server which is linked to 8000 cells in a worksheet and it works
ok, so I would not worry about 20 cells.

The push/pull mechanism in the RTD server means that excel does not get
flooded - it's an elegant architecture.

Check out the MSDN site for some examples of RTD server code / setup and
bestr practice.





--
www.alignment-systems.com


"B Deepak" wrote:

> Hi Grp,
>
> I have to excel sheets which has 10 cells each. and I have to develop a
> RTDServer using vb.net. Now I am assigning all my cells wich the RTDServer
> formula which I is to be developed. Now can anybody suggest me will this
> RTDServer face performance issue due to coninuous updates for 20 cells?
>
> Thanks,
> Deepak
>
>
>

[B Deepak]

Thanks for a quick reply.

I have a java program which will continuosly send data over TCP channel. And
our RTD server receives the data from same TCP channel. And will process the
data and then sends the notification to the excel about the updates. And
then excel sheet invokes update method to update with new values.
I have two tables which needs to be updated. So will it create performance
problem?
Now, I think u r preety confortable with what I want to do?

Thanks n Regards,
Deepak

"John.Greenan" <[email protected]> wrote in message
news:[email protected]...
> Without knowing exactly what you are doing it's not possible to answer,
> but I
> run an RTD server which is linked to 8000 cells in a worksheet and it
> works
> ok, so I would not worry about 20 cells.
>
> The push/pull mechanism in the RTD server means that excel does not get
> flooded - it's an elegant architecture.
>
> Check out the MSDN site for some examples of RTD server code / setup and
> bestr practice.
>
>
>
>
>
> --
> www.alignment-systems.com
>
>
> "B Deepak" wrote:
>
>> Hi Grp,
>>
>> I have to excel sheets which has 10 cells each. and I have to develop a
>> RTDServer using vb.net. Now I am assigning all my cells wich the
>> RTDServer
>> formula which I is to be developed. Now can anybody suggest me will this
>> RTDServer face performance issue due to coninuous updates for 20 cells?
>>
>> Thanks,
>> Deepak
>>
>>
>>

[John.Greenan]

Hi Deepak,

Provided all the code is written well it doesn't sound like there will be
any problems at the Excel end. For the excel part the RTD is almost self
managing in that excel will only ask for updates when it's available.

You should think about how you want to get updates into excel - if the
server is being throttled do you want to send a complete list of all updates
for one cell into Excel or just send the latest? Sending a complete list of
updates can be problematic if you have lots of cell dependencies. If excel
is just acting as a pure presentation layer then there should be no problems,
but sending lots of updates when there are lots of dependent cells will slow
excel.



--
www.alignment-systems.com


"B Deepak" wrote:

> Thanks for a quick reply.
>
> I have a java program which will continuosly send data over TCP channel. And
> our RTD server receives the data from same TCP channel. And will process the
> data and then sends the notification to the excel about the updates. And
> then excel sheet invokes update method to update with new values.
> I have two tables which needs to be updated. So will it create performance
> problem?
> Now, I think u r preety confortable with what I want to do?
>
> Thanks n Regards,
> Deepak
>
> "John.Greenan" <[email protected]> wrote in message
> news:[email protected]...
> > Without knowing exactly what you are doing it's not possible to answer,
> > but I
> > run an RTD server which is linked to 8000 cells in a worksheet and it
> > works
> > ok, so I would not worry about 20 cells.
> >
> > The push/pull mechanism in the RTD server means that excel does not get
> > flooded - it's an elegant architecture.
> >
> > Check out the MSDN site for some examples of RTD server code / setup and
> > bestr practice.
> >
> >
> >
> >
> >
> > --
> > www.alignment-systems.com
> >
> >
> > "B Deepak" wrote:
> >
> >> Hi Grp,
> >>
> >> I have to excel sheets which has 10 cells each. and I have to develop a
> >> RTDServer using vb.net. Now I am assigning all my cells wich the
> >> RTDServer
> >> formula which I is to be developed. Now can anybody suggest me will this
> >> RTDServer face performance issue due to coninuous updates for 20 cells?
> >>
> >> Thanks,
> >> Deepak
> >>
> >>
> >>
>
>
>

[B Deepak]

thnx a lot John. I will ping u if I face any performance issue(hopefully
there shud be no per. issue).
"John.Greenan" <[email protected]> wrote in message
news:[email protected]...
> Hi Deepak,
>
> Provided all the code is written well it doesn't sound like there will be
> any problems at the Excel end. For the excel part the RTD is almost self
> managing in that excel will only ask for updates when it's available.
>
> You should think about how you want to get updates into excel - if the
> server is being throttled do you want to send a complete list of all
> updates
> for one cell into Excel or just send the latest? Sending a complete list
> of
> updates can be problematic if you have lots of cell dependencies. If
> excel
> is just acting as a pure presentation layer then there should be no
> problems,
> but sending lots of updates when there are lots of dependent cells will
> slow
> excel.
>
>
>
> --
> www.alignment-systems.com
>
>
> "B Deepak" wrote:
>
>> Thanks for a quick reply.
>>
>> I have a java program which will continuosly send data over TCP channel.
>> And
>> our RTD server receives the data from same TCP channel. And will process
>> the
>> data and then sends the notification to the excel about the updates. And
>> then excel sheet invokes update method to update with new values.
>> I have two tables which needs to be updated. So will it create
>> performance
>> problem?
>> Now, I think u r preety confortable with what I want to do?
>>
>> Thanks n Regards,
>> Deepak
>>
>> "John.Greenan" <[email protected]> wrote in message
>> news:[email protected]...
>> > Without knowing exactly what you are doing it's not possible to answer,
>> > but I
>> > run an RTD server which is linked to 8000 cells in a worksheet and it
>> > works
>> > ok, so I would not worry about 20 cells.
>> >
>> > The push/pull mechanism in the RTD server means that excel does not get
>> > flooded - it's an elegant architecture.
>> >
>> > Check out the MSDN site for some examples of RTD server code / setup
>> > and
>> > bestr practice.
>> >
>> >
>> >
>> >
>> >
>> > --
>> > www.alignment-systems.com
>> >
>> >
>> > "B Deepak" wrote:
>> >
>> >> Hi Grp,
>> >>
>> >> I have to excel sheets which has 10 cells each. and I have to develop
>> >> a
>> >> RTDServer using vb.net. Now I am assigning all my cells wich the
>> >> RTDServer
>> >> formula which I is to be developed. Now can anybody suggest me will
>> >> this
>> >> RTDServer face performance issue due to coninuous updates for 20
>> >> cells?
>> >>
>> >> Thanks,
>> >> Deepak
>> >>
>> >>
>> >>
>>
>>
>>

[B Deepak]

And I have to apply the same formulae over all the cells. Will it affect
performance?
Are you doin the same stuff which I am trying to do?
Have u applied the same formula for 8000 cells?

Thanks,
Deepak


"B Deepak" <[email protected]> wrote in message
news:%[email protected]...
> Thanks for a quick reply.
>
> I have a java program which will continuosly send data over TCP channel.
> And our RTD server receives the data from same TCP channel. And will
> process the data and then sends the notification to the excel about the
> updates. And then excel sheet invokes update method to update with new
> values.
> I have two tables which needs to be updated. So will it create performance
> problem?
> Now, I think u r preety confortable with what I want to do?
>
> Thanks n Regards,
> Deepak
>
> "John.Greenan" <[email protected]> wrote in message
> news:[email protected]...
>> Without knowing exactly what you are doing it's not possible to answer,
>> but I
>> run an RTD server which is linked to 8000 cells in a worksheet and it
>> works
>> ok, so I would not worry about 20 cells.
>>
>> The push/pull mechanism in the RTD server means that excel does not get
>> flooded - it's an elegant architecture.
>>
>> Check out the MSDN site for some examples of RTD server code / setup and
>> bestr practice.
>>
>>
>>
>>
>>
>> --
>> www.alignment-systems.com
>>
>>
>> "B Deepak" wrote:
>>
>>> Hi Grp,
>>>
>>> I have to excel sheets which has 10 cells each. and I have to develop a
>>> RTDServer using vb.net. Now I am assigning all my cells wich the
>>> RTDServer
>>> formula which I is to be developed. Now can anybody suggest me will this
>>> RTDServer face performance issue due to coninuous updates for 20 cells?
>>>
>>> Thanks,
>>> Deepak
>>>
>>>
>>>
>
>

[John.Greenan]

"And I have to apply the same formulae over all the cells. Will it affect
performance?"
I don't know what the formula is, so I cannot answer that.

What I am telling you is this - 20 cells, in a normal workbook, with normal
formulae will be ok. Since I cannot see your code and don't have the time to
review it anyway, all I can tell you is what I know based on 3 years
experience with using RTD servers.

As I have said below, I have a spreadsheet pulling 8000 data items using
8000 =RTD(...) equations from an RTD server and it works fine. The RTD takes
data from a TCP socket and formats it for excel and lets excel grab the data
using =rtd(....)

So, 20 cells is not going to cause a scale issue if you write the RTD server
properly.

Good luck.



--
www.alignment-systems.com


"B Deepak" wrote:

> And I have to apply the same formulae over all the cells. Will it affect
> performance?
> Are you doin the same stuff which I am trying to do?
> Have u applied the same formula for 8000 cells?
>
> Thanks,
> Deepak
>
>
> "B Deepak" <[email protected]> wrote in message
> news:%[email protected]...
> > Thanks for a quick reply.
> >
> > I have a java program which will continuosly send data over TCP channel.
> > And our RTD server receives the data from same TCP channel. And will
> > process the data and then sends the notification to the excel about the
> > updates. And then excel sheet invokes update method to update with new
> > values.
> > I have two tables which needs to be updated. So will it create performance
> > problem?
> > Now, I think u r preety confortable with what I want to do?
> >
> > Thanks n Regards,
> > Deepak
> >
> > "John.Greenan" <[email protected]> wrote in message
> > news:[email protected]...
> >> Without knowing exactly what you are doing it's not possible to answer,
> >> but I
> >> run an RTD server which is linked to 8000 cells in a worksheet and it
> >> works
> >> ok, so I would not worry about 20 cells.
> >>
> >> The push/pull mechanism in the RTD server means that excel does not get
> >> flooded - it's an elegant architecture.
> >>
> >> Check out the MSDN site for some examples of RTD server code / setup and
> >> bestr practice.
> >>
> >>
> >>
> >>
> >>
> >> --
> >> www.alignment-systems.com
> >>
> >>
> >> "B Deepak" wrote:
> >>
> >>> Hi Grp,
> >>>
> >>> I have to excel sheets which has 10 cells each. and I have to develop a
> >>> RTDServer using vb.net. Now I am assigning all my cells wich the
> >>> RTDServer
> >>> formula which I is to be developed. Now can anybody suggest me will this
> >>> RTDServer face performance issue due to coninuous updates for 20 cells?
> >>>
> >>> Thanks,
> >>> Deepak
> >>>
> >>>
> >>>
> >
> >
>
>
>

[B Deepak]

Hi John,

We r doin the same stuff which u d talked abt.
We r taking data frm TCP Client, process it n update it into the excel
sheet. Now I ve not doubts about the performance issue, so ll ping u if any
probelms.

Thanks a lot,
Deepak


"John.Greenan" <[email protected]> wrote in message
news:[email protected]...
> "And I have to apply the same formulae over all the cells. Will it affect
> performance?"
> I don't know what the formula is, so I cannot answer that.
>
> What I am telling you is this - 20 cells, in a normal workbook, with
> normal
> formulae will be ok. Since I cannot see your code and don't have the time
> to
> review it anyway, all I can tell you is what I know based on 3 years
> experience with using RTD servers.
>
> As I have said below, I have a spreadsheet pulling 8000 data items using
> 8000 =RTD(...) equations from an RTD server and it works fine. The RTD
> takes
> data from a TCP socket and formats it for excel and lets excel grab the
> data
> using =rtd(....)
>
> So, 20 cells is not going to cause a scale issue if you write the RTD
> server
> properly.
>
> Good luck.
>
>
>
> --
> www.alignment-systems.com
>
>
> "B Deepak" wrote:
>
>> And I have to apply the same formulae over all the cells. Will it affect
>> performance?
>> Are you doin the same stuff which I am trying to do?
>> Have u applied the same formula for 8000 cells?
>>
>> Thanks,
>> Deepak
>>
>>
>> "B Deepak" <[email protected]> wrote in message
>> news:%[email protected]...
>> > Thanks for a quick reply.
>> >
>> > I have a java program which will continuosly send data over TCP
>> > channel.
>> > And our RTD server receives the data from same TCP channel. And will
>> > process the data and then sends the notification to the excel about the
>> > updates. And then excel sheet invokes update method to update with new
>> > values.
>> > I have two tables which needs to be updated. So will it create
>> > performance
>> > problem?
>> > Now, I think u r preety confortable with what I want to do?
>> >
>> > Thanks n Regards,
>> > Deepak
>> >
>> > "John.Greenan" <[email protected]> wrote in message
>> > news:[email protected]...
>> >> Without knowing exactly what you are doing it's not possible to
>> >> answer,
>> >> but I
>> >> run an RTD server which is linked to 8000 cells in a worksheet and it
>> >> works
>> >> ok, so I would not worry about 20 cells.
>> >>
>> >> The push/pull mechanism in the RTD server means that excel does not
>> >> get
>> >> flooded - it's an elegant architecture.
>> >>
>> >> Check out the MSDN site for some examples of RTD server code / setup
>> >> and
>> >> bestr practice.
>> >>
>> >>
>> >>
>> >>
>> >>
>> >> --
>> >> www.alignment-systems.com
>> >>
>> >>
>> >> "B Deepak" wrote:
>> >>
>> >>> Hi Grp,
>> >>>
>> >>> I have to excel sheets which has 10 cells each. and I have to develop
>> >>> a
>> >>> RTDServer using vb.net. Now I am assigning all my cells wich the
>> >>> RTDServer
>> >>> formula which I is to be developed. Now can anybody suggest me will
>> >>> this
>> >>> RTDServer face performance issue due to coninuous updates for 20
>> >>> cells?
>> >>>
>> >>> Thanks,
>> >>> Deepak
>> >>>
>> >>>
>> >>>
>> >
>> >
>>
>>
>>

[B Deepak]

Hey John,

Can I use C# as a development lang. for RTDServer?
Because as of my knowledge, we can not build com dll using c#. So do I need
to continue with VB?
Which language d u used?

Thanks n Regards,
Deepak


"John.Greenan" <[email protected]> wrote in message
news:[email protected]...
> Without knowing exactly what you are doing it's not possible to answer,
> but I
> run an RTD server which is linked to 8000 cells in a worksheet and it
> works
> ok, so I would not worry about 20 cells.
>
> The push/pull mechanism in the RTD server means that excel does not get
> flooded - it's an elegant architecture.
>
> Check out the MSDN site for some examples of RTD server code / setup and
> bestr practice.
>
>
>
>
>
> --
> www.alignment-systems.com
>
>
> "B Deepak" wrote:
>
>> Hi Grp,
>>
>> I have to excel sheets which has 10 cells each. and I have to develop a
>> RTDServer using vb.net. Now I am assigning all my cells wich the
>> RTDServer
>> formula which I is to be developed. Now can anybody suggest me will this
>> RTDServer face performance issue due to coninuous updates for 20 cells?
>>
>> Thanks,
>> Deepak
>>
>>
>>

[John.Greenan]

Yes you can use c#. Create the server and then create an interop layer.
That works.

--
www.alignment-systems.com


"B Deepak" wrote:

> Hey John,
>
> Can I use C# as a development lang. for RTDServer?
> Because as of my knowledge, we can not build com dll using c#. So do I need
> to continue with VB?
> Which language d u used?
>
> Thanks n Regards,
> Deepak
>
>
> "John.Greenan" <[email protected]> wrote in message
> news:[email protected]...
> > Without knowing exactly what you are doing it's not possible to answer,
> > but I
> > run an RTD server which is linked to 8000 cells in a worksheet and it
> > works
> > ok, so I would not worry about 20 cells.
> >
> > The push/pull mechanism in the RTD server means that excel does not get
> > flooded - it's an elegant architecture.
> >
> > Check out the MSDN site for some examples of RTD server code / setup and
> > bestr practice.
> >
> >
> >
> >
> >
> > --
> > www.alignment-systems.com
> >
> >
> > "B Deepak" wrote:
> >
> >> Hi Grp,
> >>
> >> I have to excel sheets which has 10 cells each. and I have to develop a
> >> RTDServer using vb.net. Now I am assigning all my cells wich the
> >> RTDServer
> >> formula which I is to be developed. Now can anybody suggest me will this
> >> RTDServer face performance issue due to coninuous updates for 20 cells?
> >>
> >> Thanks,
> >> Deepak
> >>
> >>
> >>
>
>
>

[B Deepak]

Hi John,

Thanks for ur help. Currently I am working on how to update excel region(
say excel table with 2 rows and 3 columns). And it is doable through array.
For this I have to get TCP stream and convert it into string with each
culumn seperated by comma(,) and each row is seperated by (.This is all
about parsing. After parsing get done, this string will be passed to the
excel ****. Now the job of the excel evaluate function to parse the string
and convert it into array. And this array will then
get populated into the excel region. All the above stuff is mentioned in the
belowed link...
http://support.microsoft.com/default...b;en-us;286258.

If we consider the performance, I have to remove parsing mechanism frm my
RTDServer. I mean we have to get a TCPStream and then convert it into array
which will then submitted to Excel. Now the job of the excel is to invoke
refreshdata funcion and update the region.
Is there any standart function of excel sheet like Evaluate which will take
input as array and ll display output into the specified region of an excel
sheet?
Can u plse help in doin this stuff?

Thanks n Regards,
Deepak

"B Deepak" <[email protected]> wrote in message
news:[email protected]...
> Hi Grp,
>
> I have to excel sheets which has 10 cells each. and I have to develop a
> RTDServer using vb.net. Now I am assigning all my cells wich the RTDServer
> formula which I is to be developed. Now can anybody suggest me will this
> RTDServer face performance issue due to coninuous updates for 20 cells?
>
> Thanks,
> Deepak
>

[B Deepak]

Hi John,

As mentioned in the previous post, Evaluate function takes array as a string
with column seperated by commas and rows seperated by semicolomn. Is there
any other function like Evaluate which will take input as array and ll
display that array into excel sheet region( say 2 * 3 table)?

Thanks,
Deepak
"B Deepak" <[email protected]> wrote in message
news:[email protected]...
> Hi John,
>
> Thanks for ur help. Currently I am working on how to update excel
> region( say excel table with 2 rows and 3 columns). And it is doable
> through array. For this I have to get TCP stream and convert it into
> string with each culumn seperated by comma(,) and each row is seperated by
> (.This is all about parsing. After parsing get done, this string will be
> passed to the excel ****. Now the job of the excel evaluate function to
> parse the string and convert it into array. And this array will then
> get populated into the excel region. All the above stuff is mentioned in
> the belowed link...
> http://support.microsoft.com/default...b;en-us;286258.
>
> If we consider the performance, I have to remove parsing mechanism frm my
> RTDServer. I mean we have to get a TCPStream and then convert it into
> array which will then submitted to Excel. Now the job of the excel is to
> invoke refreshdata funcion and update the region.
> Is there any standart function of excel sheet like Evaluate which will
> take input as array and ll display output into the specified region of an
> excel sheet?
> Can u plse help in doin this stuff?
>
> Thanks n Regards,
> Deepak
>
> "B Deepak" <[email protected]> wrote in message
> news:[email protected]...
>> Hi Grp,
>>
>> I have to excel sheets which has 10 cells each. and I have to develop a
>> RTDServer using vb.net. Now I am assigning all my cells wich the
>> RTDServer formula which I is to be developed. Now can anybody suggest me
>> will this RTDServer face performance issue due to coninuous updates for
>> 20 cells?
>>
>> Thanks,
>> Deepak
>>
>
>