167 posts • joined 19 Apr 2010
Re: Sybase vs SQL Sevrer really?
First of all I am not the commentator who wrote about the dying niche product, not that I strongly disagree with him. I haven't seen Sybase in any new project except for old legacy apps.
So you based your performance benchmarking on some simple heavy volume transaction insertions? Do you call this a real and comprehensive test? I still find it hard to believe that SQL server was slower on the simple stuff, but ok can accept that it may be 5-10% slower for inserts if I understand your test correctly.
However, Performance testing is executing complex queries, running complicated stored procedures, testing user load from simultaneous connections while inserting/updating data. This is what users do on a daily basis, this is where the database goes slow and separates the men from the boys. You have my email address, so do contact me.
If you set-up your Sybase env and install sql server, I can remote desktop via logmein or similar. I am sure we will find a way if you really want to know the truth. But as I said I have done numerous very comprehensive tests and SQL Server easily beats Sybase. And I see this on a regular basis in my job, I have to use Sybase.
Re: Sybase vs SQL Sevrer really?
Are you talking about a comparison between SQL Server when it was released in 1994 with the 1994 Sybase or something recent? Must be the 1994 version you last compared.
"I much prefer ASE for its performance and ease of use" where is the ease of use with Sybase, I am losing you here. It doesn't even have a proper SQL Development env I am using something that was hacked together by Sybase. Compare this to tools you get with SQL Server. Unless you prefer using the command prompt and you find this easier.
Why don't you put your money where your mouth is if you feel so confident with Sybase, £300 bet for the winner. I challenge you to beat SQL Server with any bit of SQL you want (has to be reasonably complex) not a join between 2 tables!. We run on same machine, same indexes, same data, I guess you want Linux, I use sql server 2008. You provide the SQL (or have plenty SQL anyway), we need few tables with some million rows each. You devise the SQL tests, but needs to be complex sql.
Contact me at sqlsybase at gmx.com if you would like to win £300.
As of Hana, this is not a proper relational database and have never seen it on a Sybase install. Should I mention tabular then on sql server then? SQL server has in-memory since 2012. Check the 2 billion rows it can query in 1 second white paper. But lets keep this simple RDBMS vs RDBMS (ACID compliant) systems only.
For the people who say Linux or windows or whatever, the Database is a fast as the optimiser is. Awaiting your email...
Why Oracle doesn't take on the more up to date and more difficult TPC-E benchmark and stays with the 1994 devised test? The tpc-c test is a database with 5-10 tables, the tpc-E is a proper trading database.
So how do you know that your custom ROM hasn't been "touched" to run some other nasty sniffer stuff in the background, and send 100 SMS to Angola while you are asleep? In fact there is no limit what it can do! I am sure most of the stuff is OK but there is a big IF.
The whole post from Bernstein is based on google analytics comparison between nokia lumia and iphone 4s. I used the same graph and the lumia has a much higher hit rate than Samsung s2 when it first came out and right now has about half the hits of the Samsung s2. So if these analytics are to be believed it will have half the sales of Samsung s2 which isn’t a bad thing IMHO. Is Bernstein shorting nokia by the way?
not social networks
It syncs with your hotmail, gmail account, facebook etc is additional option you can disable. It syncs with exchange but not your local outlook. Of course your local outlook may already be syncing with your hotmail. Personally I found it little inconvenient but once I stored my address data in hotmail I know they are always accessible from anywhere in the world and won't bother with my local outlook again.
you can officially unlock it
There is a official app that allows you to unlock your windows phone. It's called chevron. On another note, today I was comparing my htc mozart screen windows phone general functionality with my friend's iphone 3GS. Internet was much faster than my friend's but probably the netwrok to blame to a degree. But I was really surprised my screen looked so much more vivid and bright. He didn't get some setting on as far as he knows and no screen protection. I thought the iphone 4 screen was good but maybe not!
It doesn't have the RAM cause it doesn't need it. The N9 comes with 1G as do many of the top androids. Can't say about meego but an android with 500MB, 1 core runs like a dog. Any windows phone 7 Mango is more fluid than the best android.
Answers to the aboves is yes. And people started received the update already the same day it was announced, seems like this time the process has been streamlined and they won't be the small delay. Now compare this to Android .... How many androids are running the latest version and they are not brand new?
Currently it is the android phones that need 2 cores just to keep up with the windows phone. If you have used a WP you will know it beats easily any android for any normal phone operations, browsing contacts, viewing pictures, anything you do in a phone. Where is about equal is the browser but with the new IE9 I expect WP to be faster. All the above with exactly half the hardware of an android. If you don't believe give it a try.
Eclipse is one word to give me a heart attack. Avoid it at all costs.
Have you? I have been using one for the past 6 months and I take my word is faster than the androids running double the hardware. With Mango will be really excellent.
that explains it
That explains then why they have 960,00 servers, see earlier article in the register. May God bless them with a million.
"If MS did an Apple and stopped supporting/developing it?"
The second most popular database in the world that makes tonnes of money for Microsoft won't be supported anymore? You must be kidding more than the original comment I replied to. SQL Server currently has the top spot in TPC-E test (top 10 actually). Try to beat SQL Server with Oracle first before you attempt with Postgress.
Alternatively, spend another 10 months trying to optimise your system to run at a reasonable speed on mySQL. You have a very narrow minded view of software development. By far the most expensive bit of your system is the personnel you employ not the software (unless you are talking about SAP, Oracle etc which can cost 100K easy).
But your point is valid if your system has 1 table so in this case mysql can run as fast but that's not the typical scenario.
Why would I want to move my SQL Server database to mySQL. You must be kidding.
I checked the oscommerce.com website. Quality PHP, mySQL implementations springs to mind, although any system if not implemented properly is vulnerable. When will people understand that using the best software is actually cheaper.
OK, I see your point, but a transaction needs error handling, this is how I used them for the past 10 years anyway. I am not sure about Oracle and how it handles it, but SQL Server and Sybase behave this way. In fact if you don't put some error handling you may end up with a locked table cause the commit didn't execute and the rollback doesn't exist in the code.
One of the reasons is that I may want to do something specific after the error, if by default it rolls back I can't write to a audit table to capture the error cause it will rollback the audit write op. It's similar with .NET or Java, appropriate error handling makes things easier but that's the price you have to pay.
We are turning this into a sql forum but if you have the following around your transaction it never fails. The select only gives a,b,c. Hope that helps.
-- now the interesting bit
insert into #tbl values('b');
insert into #tbl values('c');
insert into #tbl values('d');
if @@TRANCOUNT > 0
where is the rollback?
Personally when I am using a begin and commit tran I always have a catch error statement. So your block should have a rollback statement if things goes wrong. Check the TRY-CATCH block in online help.
I don't see anything wrong with the behavior of SQL Server above, if you had the rollback statement though then your table wouldn't have the 'd' value. This is standard coding practice. At least SQL server has a very neat way to handle errors. Not all DBMS have this lovely try-catch.
I agree with another post, unfortunately these nice tools in Visual studio give the .NET programmers the impression that they don't need to really understand databases and SQL. I have seen some really bad examples of coding (especially with hibernate) and jumping out of the windows wasn't enough. I am still here cause I was on the ground floor!.
Am I looking forward to Denali, certainly am, especially the SSAS that will be able to be more efficient with not analytics only.
there is a third option...
it's called Windows phone, it's like apple take or leave it but at least you don't have to pay through your nostrills. Other apps that compete with microsoft are allowed too.
I've read somewhere that Facebook uses 65,000 servers so has to be true if they have 4000 mysql servers going to 9000. Probably the same data can happilly run in 2-3 proper commercial server databases like SQL Server or Oracle (ok it may require 250 cores but will happilly run). Don't forget the whole point about a database is query optimisation, you don't have that in your engine you are dead. Not all SQL is the same.
agree, then the canadian company wouldn't be able to sue microsoft for their xml patent. what needs reform is the patent system.
So I think we need to burn more fossil fuels to warm up our planet if it’s going to cool down drastically. This decade will be the decade of the global cooling scaremongering. I personally don’t take notice of any of the climate brigade, they credibility was lost somewhere between cow’s farts and sheep bad breath.
another good example
Can someone explain to me why Microsoft can't bundle their free microsoft security essentials antivirus which is by the way an excellent product with windows? Or why they don't have silverlight pre-installed with windows? Cause other companies complained. So that's why Google having gained a dominant position may abuse it and needs to be checked. I am not saying I have a proof they do but can't see their search engine algorithms fully.
Lets make sure google behave fairly. Also, if microsoft has to provide that broswer question, then why not apple. I bet 90% of macs are using safari!!??
apples to motorbikes are not the same
If Microsoft had stolen an apple from Sun, Google have stolen a car. If microsoft were successfully sued by Sun for developing a similar language, then oracle have a pretty good chance to sue Google for using their source code (and patents). From what I remember from another Register article it's not just patents, it includes the same source code. Google must get some vert good lawyers to get out of this.
that's not the whole story
I haven't used libreoffice but if it's as good as open office then not sure it's a good idea, we are talking about business processes here, it could be very expensive to convert. Also, the NHS is not just using Office, it's using SQL Server, sharepoint and the works. We are talking about thousands of servers running all sorts in total. I've rworked there for a while and know few things.
Incompetent government officials who have no idea how software works making important decisions. Of course when you buy in bulk for the whole country you should be able to pay less for your purchases and get discounts.
and Windows phone
same here with my Windows Phone
We are most probably migrating to a Windows Server set-up due to the shortcomings of a certain DBMS (won't mention names) running on Unix. The database people said that if we run this database on a linux, apparently it can run faster. It can run faster cause the x86 processors have better technology (I have no comment to make on this cause have never seen the benchmarks). That's last chance to salvage anything.
But the bomb has been dropped, the Windows Server on the other DBMS offers 3-5 times the performance at a fifth of the price. I am sure with some tweaking can make little faster. You can't argue with figures like this.
have you used WP7?
Check simpleSSH Lite if you want your ssh client for WP7. Maybe it's not the best yet but works. I am not sure what you mean by decent communication apps, like messenger and the rest? There are a few. Then with mango it goes to a completely different level.
You get the best of both worlds with Windows Phone 7. Each one to his/her own.
Since when you thought that writing code is for free? I am not going to say mention my daily rate but I am not poor. Or do you expect some code monkeys to work for free for you?
why is that different?
Do you think you don't have to press OK in Windws to install something, it just installs by itself? There is always some button but to novice as most of us are it looks like a ligitimate OK. Macs are less secure than Windows generally speaking, they are just not attacked as much. Expect more similar stories in the future.
quality not quantity
Android will step on a Mango fruit in September and will get a big dent on its head! From the still very happy WP7 user (Hope all android users are very happy running their antivirus).
Android? good luck with that.
From a very happy WP7 user
and the result was....
Yahoo is almost a bankrupt company now, they use Bing's search engine cause theirs suck and npbody wants to buy them.
No not me, having seen outsourcing in the City one with a dutch bank and another with some public body it has been a total failure (not far from a joke).
deal done. It runs like it's daddy Java, like a slug.
Have you tried comparing it with a non-android phone? maybe a windows phone 7 to see if it still destroys the competition?
20% for WP7 soon(ish)
Windows Phone 7 put around 20% by gartner this time, IDC was the last one to put it around 19%.
Even though predictions are difficult it shows the dynamics. Windows phone is an excellent OS so am not surprised.
You are talking b*llshit. Are you really an IT specialist?
not another one surely!
Another “successful” outsourcing project. I’ve seen 2-3 big ones during my career in the City, all of them big failures, with the provider trying to milk as much as possible out of the contract and almost nothing gets done, politics, bickering etc. I am not surprised at all.
So what's the problem? My mobile is just going through the NoDo update as we speak, I am on orange with a mozart, so what waited for an extra month, at least I know the update will arrive it may not arrive on the day but will arrive at least within the month. This is the second update I got, give Microsoft a break, or put into prospective what you get with Android (no updates). I am sure the next update will be even smoother.
Open Source only for marketing purposes...
Considering that Windows market place is 5 months old, I think it will be very likely, and don’t need IDC for that, to be available in the rest of the world pretty soon. At least it’s more possible that Windows market place will be available in Malaysia than it will be have a higher than iphone in 4 years time.
Just for anyone reading out there, I got my update today on my htc mozart with Orange. That was the first update, not the second with cut-paste. So hopefully in the next week should get the proper one. Go Orange finish off your testing!!
when oracle can beat other databases...
When oracle can beat this I will be worried by the deal... Has anyone tried to beat the real database test with the 40 tables instead of the 8 they are falling over themselves to beat from 1992? Lets be Men Mr Ellison, give your best shot and stop hiding in your boat...
Well, looks like google want to make some money out of this. So do your contributions for free then Google can make extra money. If it makes it faster, cause it's lacking in speed compared to iphone and windows phone 7 go ahead. But can they actually make it closed source assuming the had some contributions already?
When moving to Linux?? Solaris boxes are expensive monsters than offer no real value. We are moving our database to windows server and other stuff to linux.