When to send a Query

Question

5.00/5 (1 vote)

See more:

I'll be interested in any feedback on the following design problem.
I've got a data feed that updates real time. The criteria for the data is provided by the user entering values through the UI.

We have the option to update the criteria as and when the user enters something or to allow them to enter criteria in various fields then hit a button to refresh.

Most of the fields are independent, but there can be related fields such as a date range.

Take it as read that the user's understand the data they are providing and what they would expect to be returned when the query fires.

Should we go with the auto or manual refresh?

[edit - add extra info]
The filter is entered on the same form as the data is displayed, it is a desktop app, not web.

The criteria is persisted by various methods, this is out of scope but take as read it is there.

This is read operation, the updates are coming from [potentially] hundreds of different sources, we're just reading the output.

Posted 5-Feb-10 0:35am

Nagy Vilmos

Updated 5-Feb-10 5:57am

v3

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abhishek Sur · Accepted Answer · 2010-02-05T00:48:00

You didnt mentioned where you want to do this. I think it is always better to update when the user accepts the whole page.

In the mean while, you can create a temporary memory and store it(persistent if possible).

The main database should be updated only when the user accepts the whole input.

:)