|
in ADO.NET DataReader is the absolute fastest way to access data from a database, hand's down. The performance issues you are referring to are Datatable, DataAdapter which read the schema information to do their work. The only way to appreciably slow down a datareader on a like-for-like query is to user column names instead of column indexes (or call ToString and parse everything) and those two scenarios are developer errors.
With regard to LINQ, every developer should understand the data source. Minimizing it only leads to heart-aches. LINQ, and technologies that abstract the database into a persistence layer minimize the importance and value of a proper database; and if a proper database offers your application no added value maybe you should be considering a different persistence technology.
|
|
|
|
|
While I agree with the importance of good database design, I respectfully disagree that using tools to make life easier at app development time (which LINQ is) is a bad thing. By that argument we should all still be working in C or ASM.
|
|
|
|
|
I am not convinced that LINQ makes life easier for a developer. Just because you can do something in one-statement doesn't mean you should. In fact, the type of design LINQ inspires is just, bleh. But that is just my opinion.
|
|
|
|
|
Ennis Ray Lynch, Jr. wrote: But that is just my opinion
Well no, I certainly agree with you, some linq for linqs sake is just more obfuscation, I do use it for simple job but the syntax is not intuitive and the more complex the job the worse it gets.
I'm quite comfortable using 20 lines of code if it is more readable/supportable down the track.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Yes, yes, yes. I agree 100%.
Regards,
Rob Philpott.
|
|
|
|
|
Ennis Ray Lynch, Jr. wrote: In fact, the type of design LINQ inspires is just, bleh. But that is just my
opinion.
Mine too!
Regards,
Rob Philpott.
|
|
|
|
|
Hello, sorry for my late reply.
Ah, ok, DataReader is the best choice, I have used it many, many moons ago...
I will take that into account the next time we discuss our database structure / database access.
And what you said about linq and it´s abstraction lets me reflect on it...  
|
|
|
|
|
I've just started looking at some code which is using EF or LINQ to SQL or something (there are a lot of 'contexts'). I'm used to using an SQLDataReader to get stuff out of a db and I was wondering about performance of this more modern ways.
From your experience how much faster is a data reader over the other approaches? Do you have any rough estimates?
Regards,
Rob Philpott.
|
|
|
|
|
Try This[^].
brisingr_aerowing@Gryphon-PC $ rake in_the_dough
Raking in the dough
brisingr_aerowing@Gryphon-PC $ make lots_of_money
Making lots_of_money
|
|
|
|
|
I'm still using VS2008, but in that you version can change the default framework target in in the create new project dialog. There should be a ComboBox at the top of the dialog.
Based on this picture[^], that option is still exists in VS2010.
|
|
|
|
|
That still selects the Client Profile, which is stored as default in the project template. Modifying the template fixes the issue.
brisingr_aerowing@Gryphon-PC $ rake in_the_dough
Raking in the dough
brisingr_aerowing@Gryphon-PC $ make lots_of_money
Making lots_of_money
|
|
|
|
|
Thanks for the info. I'm sure it will come in handy when I finally upgrade (if that is the right word  ).
|
|
|
|
|
Some 79% of malicious attacks on mobiles in 2012 occurred on devices running Google's Android operating system, US authorities have said.
Nokia's Symbian system, on the Finnish company's basic-feature handsets, had had the second-most malware attacks.
http://www.bbc.co.uk/news/technology-23863495[^]
|
|
|
|
|
This is rather useless statistics : if there are 100 times more Android phones in the world than iPhones, then the iPhone are less secure than Android phones.
~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
|
|
|
|
|
And given that the article counts "trojan text messages" as "android attacks"...
This message is manufactured from fully recyclable noughts and ones. To recycle this message, please separate into two tidy piles, and take them to your nearest local recycling centre.
Please note that in some areas noughts are always replaced with zeros by law, and many facilities cannot recycle zeroes - in this case, please bury them in your back garden and water frequently.
|
|
|
|
|
OriginalGriff wrote: And given that the article counts "trojan text messages" as "android attacks"...
That bit seems rather off to me too. Are text spammers just not targeting iOS users, is there some reason they're not being reported on iOS, or does Apple have a much better spam filter than Google does allowing them to almost entirely block them?
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, waging all things in the balance of reason?
Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful?
--Zachris Topelius
Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies.
-- Sarah Hoyt
|
|
|
|
|
I suspect it's because there are 7 Android phones for each 2 iOS (or iOS users don't notice it as an attack, skewing the figures even more) http://techland.time.com/2013/04/16/ios-vs-android/[^]
This message is manufactured from fully recyclable noughts and ones. To recycle this message, please separate into two tidy piles, and take them to your nearest local recycling centre.
Please note that in some areas noughts are always replaced with zeros by law, and many facilities cannot recycle zeroes - in this case, please bury them in your back garden and water frequently.
|
|
|
|
|
By global marketshare iOS should've been ~20/40% (global/US) of the total; with half the reports being hostile texts that should've naively been 10/20% of the total which is why I'm wondering about non-reporting for some reason or if Apple's just winning the text spam filtering war.
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, waging all things in the balance of reason?
Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful?
--Zachris Topelius
Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies.
-- Sarah Hoyt
|
|
|
|
|
Or Apple users assume their device is totally secure (because Apple says it is) and don't report it.
Or "selective reporting" by the statistics compilers.
Or... loads of other possibles. It might even be genuine - but I don't think you can tell is a number you are texting is Android / iOS / Windows without some kind of reply. It's more likely that phone sellers use "blocks" of mobile numbers so the next 100,000 will all be Android, say. If the spammers are just shotgun targeting pseudorandom numbers that would distort the figures as well.
This message is manufactured from fully recyclable noughts and ones. To recycle this message, please separate into two tidy piles, and take them to your nearest local recycling centre.
Please note that in some areas noughts are always replaced with zeros by law, and many facilities cannot recycle zeroes - in this case, please bury them in your back garden and water frequently.
|
|
|
|
|
OriginalGriff wrote: Or Apple users assume their device is totally secure (because Apple says it is) and don't report it.
Or "selective reporting" by the statistics compilers.
what part of "...non-reporting for some reason ..." don't those fall under. 
OriginalGriff wrote: It's more likely that phone sellers use "blocks" of mobile numbers so the next 100,000 will all be Android, say. If the spammers are just shotgun targeting pseudorandom numbers that would distort the figures as well.
 I've never heard any claim of phone numbers being assigned by device type before; and except for numbers being handed out to kids now, most cell numbers predate android and iOS. If they were assigned by device type for some reason it'd've been Palm, blackberry, flipphone, etc; groups that I'd expect to have negligible correlation with modern OS preferences.
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, waging all things in the balance of reason?
Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful?
--Zachris Topelius
Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies.
-- Sarah Hoyt
|
|
|
|
|
Dan Neely wrote: I've never heard any claim of phone numbers being assigned by device type before
What about by vendor and then by business division?
I can't speak to the market now but I know specifically, by first hand knowledge, that at one time vendors did request numbers by block.
|
|
|
|
|
|
Collin Jasnoch wrote: I think they also said it was Android 2.3
Isn't that like saying that most of the malicious software found on the PC is running on Windows 2000XP?
Not quite. PS FTFY.
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, waging all things in the balance of reason?
Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful?
--Zachris Topelius
Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies.
-- Sarah Hoyt
|
|
|
|
|
|
2k is basically gone from the market; so however bad it was it doesn't really count anymore. If you wanted to assign it to an Android version I'd go with 2.0 or maybe 1.6 (1.x is win9x). XP and 2.3 are both pathetically old versions that have appallingly high residual marketshare so I think the match fits better than to 2k.
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, waging all things in the balance of reason?
Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful?
--Zachris Topelius
Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies.
-- Sarah Hoyt
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
