simple multiple records from database

[smugford]

your suggestion is the first thing that i thought of but as you said it's not the best way.

If it was just going to be the two it would be fine. But i'm sure it's going to extend through a loop.

In the stocklist example i see a syncronize(SubscribedItems) function.

I do understand what your talking about with the index key. I develop php web apps using mysql so the unique key concept is not a new one to me.

I think all i need is to know how to make the subscribed items based on those keys loop through and subscribe.

Can i pay someone to actually do this code?

If i can't find a solution I will have to look at a different product which is disappointing because i'm sure lightstreamer is more than capable of doing what we want

It seems like it would be really easy for someone with just a little bit of experience.

Thank you very much for your help i'll continue trying to make it work.

[DarioCrivelli]

Let me add a few Lightstreamer-related notes.

If your aim is to perform one single loop, fetching all the rows of the "data" table at regular times,
so that, upon each row found, you can update the corresponding subscription (i.e. the item which corresponds with the row key),
this is also feasible.
Just consider that, for each line found, you will have to check whether the corresponding item is currently subscribed to,
because only in this case can update or smartUpdate be invoked
(hence the need to synchronize on subscribedItems, i.e. the set of the active subscriptions).

Such a loop should be active anytime there is at least one active subscription; you may choose to start it at Data Adapter initialization and keep it always running.

Obviously, depending on the size of the table and the client activity, most of the loop operations may be redundant.
Also note that, as long as the contents of the table don't change for a key, the updates you send for that key are also redundant: the Server will recognize that nothing has changed and will just discard the update.