|
Well I'm still rebuilding the UI so I dunno...
And a lot of searching happen on new table where I have little data so it should be fine (for now...)
But hey, basically it look at all the row and columns of big tables so.. it... would be slow!
|
|
|
|
|
I am a complete noob at database + web programming, so I may be completely wrong, but this seems to me as an overkill. In my simple mind, SQL has always been something that should remain very simple to access/update data, the logic being made by the main code.
~RaGE();
I think words like 'destiny' are a way of trying to find order where none exists. - Christian Graus
Do not feed the troll ! - Common proverb
|
|
|
|
|
Your faulty logic lies in over simplification....
I assure you the C# linq friendly version would suffer from tremendous performance issue....
To give you an idea in pseudo C# I search for RTF by looking at all the below fields
RTF
int ID
string Name
AnswerSet Answer
AnswerSet
DateTime LastModified
string ModifiedBy
List<Answer>
Answer
int questionID
AnswerType type
string vString
decimal vNum
Date vDate
bool vBool
List<Option> vOptions
Option
int ID
string Name
now the user can build with a simple UI a list of criteria which looks like that
Criteria
int groupID
bool isGroupAndOrOr
CriteriaType cType
int? questionID
int? wellKnowID
object value
Now tell me how you can do this search in just 1 SIMPLE DB CONNECTION AND CALL
|
|
|
|
|
Super Lloyd wrote: Now tell me how you can do this search in just 1 SIMPLE DB CONNECTION AND CALL
Install a local Google search engine.
|
|
|
|
|
Congrads! Now you are a junior SQL programmer.
|
|
|
|
|
Well for me at least.
I have a similar stored procedure ... well actually it is broken up into 5 parts, each more daunting than the rest. But, ..., the EPA changes its mind a lot and bases forward rules on past and forward conditions so, well, it is slow, slow mess.
For a lark, I loaded the entire DB into ram and processed the data for about 5 years with code and dictionaries and achieved the same result which previously took hours in seconds.
As such, I really advocate SQL Server as a dumb vessel. (heck, I have a partitioned view right now that still doesn't work right, SQL Server continuously refuses to use the partitions constraints (which are valid btw))
|
|
|
|
|
no doubt memory search will be way faster!!!
|
|
|
|
|
I would like to store my freelance and hobby projects in web repository.
At the moment I have no intention in sharing them.
Can you recommend me a good service or solution?
Bitbucket[^] and Assembla [^] have caught my eye, but affordable web hosting solution with repository would be nicer as I'm in the process of changing my hosting provider .
Mislim, dakle jeo sam.
|
|
|
|
|
Why not just host your own? There are plenty of good tools out there to do so.
"I've seen more information on a frickin' sticky note!" - Dave Kreskowiak
|
|
|
|
|
I have a hosting account with 1&1 and they provide online storage with hosting accounts.
|
|
|
|
|
I use CloudForge[^] - free SVN or Git & their own TeamForge product
Quote: CollabNet TeamForge integrates software configuration management (SCM), continuous build and test, issue tracking, project management, lab management, and collaboration tools into a single Web-based application lifecyle management platform that empowers distributed teams to deliver great software.
which I haven't used yet but looks quite nice.
|
|
|
|
|
This looks promising.
Mislim, dakle jeo sam.
|
|
|
|
|
|
|
Mike Hankey wrote: Ah the fond horrid memories!
FTFY
|
|
|
|
|
Thought of VMS for the first time in years a couple of days back...
Ger
|
|
|
|
|
Ger Hayden wrote: Thought of VMS for the first time in years a couple of days back...
Did you have nightmares? I do when I think of VMS!
The report of my death was an exaggeration - Mark Twain
Simply Elegant Designs JimmyRopes Designs
I'm on-line therefore I am.
JimmyRopes
|
|
|
|
|
No - They come when I think of BULL-GCOS6...
Ger
|
|
|
|
|
"unix is free (and worth every cent)...."
|
|
|
|
|
|
All those ad wards... is that where sick ads go?
|
|
|
|
|
_Damian S_ wrote: All those ad wards
What is ad wards?
|
|
|
|
|
It's in a big building full of sick people.
Or your subject, one or the other.
Perhaps you should get an award for your adward?
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
|
|
|
|
|
OriginalGriff wrote: Perhaps you should get an award for your adward?
Now I will have to leave it like that.
|
|
|
|
|
I love the comments and laughter from the guys recording it
But why would he be dancing right there?
Soren Madsen
"When you don't know what you're doing it's best to do it quickly" - Jase #DuckDynasty
|
|
|
|