|
In my experience, when it comes to "combinatorial explosions", your projections (i.e. $columns) and ordering (i.e. $orderBy) are not as much a problem as the query conditions themselves: you will need to hard-code nearly as many values passed for the $where as the number of 'get<...>by<...>' functions you previously needed to code.
The solution I've been using is generating my 'where' clauses dynamically. This way, instead of pre-made 'where' clauses you'd build collections of uniform items from which your SQL can be generated. For example, a list of name-value pairs could be used to generate a conjunction like name1=value1 AND name2=value2 AND ... nameN=valueN. More advanced solutions include use of expression libraries, such as LINQ's Expression in .NET, to formulate composite queries of arbitrary complexity (with 'OR's, 'AND's, 'NOT's, and function calls).
P.S. Any time you generate SQL dynamically you should be very careful to avoid the SQL Injection Trap; other than that, you should be OK.
|
|
|
|
|
I writing some application that find ( according to some question ) information about some person ( lets say that the information are weight, hight and age of the person ).
In the other hand i have product list ( can be very big one ) and according to the product information i need to find the best matching between the person information and the product ( the product information that i have are water part, nitrogen part and ext. )
I can't use flow chart algorithm or Breadth-first search because the number of the product is dynamically ( read the product list from DB ... )
|
|
|
|
|
Since much detail has been left out (which is expected, given that it's an architecture forum) I'd make an assumption that finding the "best matching" can be expressed mathematically as finding an extremum of a function of some sort, and that the product list is stored in a SQL database.
Suppose that the quality of the match can be evaluated as a function MatchQuality. When you get parameters of a person for whom you're finding a matching product, you can build a SQL query that corresponds to your MatchQuality function and the parameters of the given person. Consider this silly example: suppose your MatchQuality(age, weight, water, nitro) = age^2/nitro + water/weight, and the match is best when MatchQuality is highest. A query for the best product comes in: weight=170lb, age=65yr. The query below returns the best match:
select top 1
from Products
order by (65*65)/nitro + water/170 desc
|
|
|
|
|
Hello friends,
Recently, I have cleared MCTS(70-502)-WPF certification, and have already cleared the MCTS(70-536) which credits to a MCTS certification to me now.
Now, I have been looking forward to MCPD. As there are no training kits/books available for MCPD, as is present for MCTS.
Need some guidance in preparing for the MCPD exam. I do not have much experience in designing the applications and wanted to learn the same.
Please guide me on how to develop an appetite for designing the application without losing focus and which are the best books/tutorials to refer for designing a GUI windows based applications. Also, how to prepare for MCPD.
Apologies if I have posted this question in the wrong forum.
Thanks in advance,
Praveen Raghuvanshi
Software Developer
|
|
|
|
|
Rags1512 wrote: As there are no training kits/books available for MCPD
This list[^] would seem to contradict that assertion.
Just say 'NO' to evaluated arguments for diadic functions! Ash
|
|
|
|
|
Thanks Rich for the information.
However if you visit this page http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-518&locale=en-us#tab3[^] , and move to the Preparation Materials tab, you can see that there are no Microsoft book available. I am basically targeting MCPD 70-518.
I would you appreciate if you can guide me in terms of MCPD 70-518.
Also, If someone can guide on how to learn and adapt designing of application.
Thanks,
Praveen Raghuvanshi
Software Developer
|
|
|
|
|
Sorry, but I don't work for Microsoft. The link I gave you was the result of a Google search which offers various web sites with information that may help.
Just say 'NO' to evaluated arguments for diadic functions! Ash
|
|
|
|
|
I was reading a coding style document put out by a certain company, when I came across an odd claim in their justification for their FOR loop style. I was wondering if someone could shed some light on this for me:
The document states that a pre-increment operator is preferable to a post-increment operator because post-increment introduces potential inefficiencies when iterating over an object. The example they give is C++ code:
std::vector v;
for (std::vector::const_iterator i = v.begin(); i != v.end(); ++i)
{
}
...and an identical sample that uses "i++" instead of "++i" for the increment operation.
I see no difference in the efficiency. Whether using ++i or i++, "i" is going to contain its new value before the termination condition is evaluated. The loop will be iterated an identical number of times.
I was wondering if someone could shed some light on what it is that I'm missing here, or if perhaps the assertion that pre-increment is more efficient. Is there some other language or platform that treats identical FOR loop sytax in a wildly different manner?
|
|
|
|
|
i++;
++i;
In reality most modern compilers will optimise the code so it is of little consequence to the majority of programmers. It only becomes an issue if your program needs to run at sub-atomic speeds.
Just say 'NO' to evaluated arguments for diadic functions! Ash
|
|
|
|
|
Their statement is utter non-sense, as Richard already explained.
And furthermore they should concentrate on the termination test of the for loop; v.end() is getting evaluated over and over, not necessarily what is required (depends on how "alive" v is).
|
|
|
|
|
Yeah, I HATE seeing that in loops. Coders think its efficient because they have less code without thinking that a function call in the conditional part of the loop gets called every itteration.
"It is a remarkable fact that despite the worldwide expenditure of perhaps US$50 billion since 1990, and the efforts of tens of thousands of scientists worldwide, no human climate signal has yet been detected that is distinct from natural variation."
Bob Carter, Research Professor of Geology, James Cook University, Townsville
|
|
|
|
|
I was going to say you should take a look at this code disassembled to see if there is any inefficiency, but Richard has answered that already.
"It is a remarkable fact that despite the worldwide expenditure of perhaps US$50 billion since 1990, and the efforts of tens of thousands of scientists worldwide, no human climate signal has yet been detected that is distinct from natural variation."
Bob Carter, Research Professor of Geology, James Cook University, Townsville
|
|
|
|
|
As Richard and Luc have explained, there is no difference in this case. What they MAY have been referring to is this:
a[i++] = x;
b[++j] = z;
In a primitive CPU, the code might compile to something like this (much liberties taken in pseudo assembler code!)
load r1,i
add r1,=a
load r2,x
store r2,(r1)
load r1,i
inc r1
store r1,i
load r1,j
inc r1
store r1,j
add r1,=b
load r2,z
store r2,(r1)
In the early days of C, there were machines that stupid, but by the time C++ came along, the "issue" was long gone. Essentially, it's about using ++i in an expression compared to using i++. If the value of the side effect isn't used, there's no real difference.
Cheers,
Peter
Software rusts. Simon Stephenson, ca 1994.
|
|
|
|
|
Pre-increment's return value is the iterator itself, while post-increment must return a copy of the iterator before it has been incremented. Since the for loop discards the return value, using the pre-increment version of the ++ operator saves some CPU cycles by not making a copy that will be discarded anyway. A longer explanation is here.[^]
Edit: Oops, I did not see that there were so many replies already. Only the OP was visible at the bottom of the forums window.
|
|
|
|
|
Where's best to start for doing diagrams?
I want to teach myself to plan RIGHT for developing a decent sized project. Is UML still the appropriate standard? What processes should I follow?
I was taught to use Conceptual Schema and Nassi Schneiderman diagrams at school, so I'm looking for something a little more modern. :P
Thanks!
Don't forget to rate my post if it helped! 
"He has no enemies, but is intensely disliked by his friends."
"His mother should have thrown him away, and kept the stork."
"There's nothing wrong with you that reincarnation won't cure."
"He loves nature, in spite of what it did to him."
|
|
|
|
|
dawmail333 wrote: Where's best to start for doing diagrams?
Depends on the job being done, but generally state transition diagrams and event trace diagrams are pretty usefull. (and often the only diagrams done)
"It is a remarkable fact that despite the worldwide expenditure of perhaps US$50 billion since 1990, and the efforts of tens of thousands of scientists worldwide, no human climate signal has yet been detected that is distinct from natural variation."
Bob Carter, Research Professor of Geology, James Cook University, Townsville
|
|
|
|
|
Being a father of children with special needs, I am always asking
myself , with what I know how can I make a difference in my kids
life and others.
What I am looking for here is focus. What platform? What languages
should I learn? So that I can design software that helps individual
that have extra challenges in their life.
We need something cheap, a lot of families that have people with
special needs in them, most extra money goes to medical care, and
other various expenses other have no idea of.
We need something portable and has touch screen. The mouse
and keyboard while a great invention, acts as a barrier sometimes
to people that have disabilities especially mental. Touch is easy.
What platform would met those needs, while having a low cost?
|
|
|
|
|
You can get cheap tablets these days running Android. Here in the UK, Binatone have cheap Android Homesurf tablets on sale for £130. You'd obviously need to develop for Android here, but the good news is that it's free to develop for.
|
|
|
|
|
So that would be using Java and eclipse as my development environment?
Android doesnt have any visual studio tools do they? I have the express
version at home, and use a professional version at work.
I could tackle learning java for that..
|
|
|
|
|
|
Thank so you so much for the suggestion and help.
Got it all installed, did the hello world thing.
It rocks.
Now to get a better understanding of Java and android
and I am ready to help some kids.
|
|
|
|
|
Great. Wish you good luck.
If u can Dream... U can do it
|
|
|
|
|
Forget about the technology and work with those who are prepared to contribute. If their skill-set is Java, go with Java, if there skill-set is .NET, go with .NET. Work with the people, not the technology.
If you are it! There is a steep learning curve. It's worth while but don't expect to get anywhere in a hurry. Maybe the quickest is VB.NET
Architecture is extensible, code is minimal.
modified on Tuesday, January 4, 2011 9:30 AM
|
|
|
|
|
Thank you for that, appreciate that. I must admit that mostly I am looking
at cost. Lots of special need families dont have the money laying around
to afford the devices from Apple or microsoft. Google offers a cheaper solution
that more people can afford. Yes java is a learning curve for me, going to take
time to get there. Also want to provide these applications for free, the
cost of development for me, I can afford and will allow me to make my
applications free. Its a labor of love.
|
|
|
|
|
So who are these people and what are your goals? Maybe the Codeproject community can help.
Architecture is extensible, code is minimal.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
