I think you will find if that you do the simple mechanism of preparing statements, postgresql queries are just as fast even if in the form of 'select a,b,c from t where k' type queries. if you don't believe me, try it yourself. the speed advantage of mysql is highly overated.
mysql is *not faster than postgresql, even with myisam tables. postgresql has a much smarter query analyzer and on a query to query level is on par with mysql *if* you prepare the statement first. this wasn't true in the 7.x days, but it is true today.
we bought coraid devices, and they are AoE is much simpler (read: cheaper) than iSCSI. when using jumbo frame switches/cards, we were able to get transfer rates very near theoritical limits on gigibit links, something I have never seen on iSCSI or fc for that matter.
the only thing that bothers me about AoE is there is only a single vendor supporting it at the moment. other than that, it is great stuff. while it is not routable in the sense ip is routable, you can do creative things with ethernet switches and vlan basically giving san like functionality at a fraction of the cost. no longer do you have to keep dual fc/cat6 infrastructure in your server farm.
it's cheap, and if/when it supports bonding lines, well beat fc in performance (comparing two gigabit fc vs/ bonded gigabit ethernet).
first rule of database programming: never trust the application. It is easy (even trivial) to do constraint checking on the database that is absoltely infallable. It is much easier to secure a database than an appliation in fact. The problem is that people focus security in the wrong place, the application.
Slony I requires a primary key on all tables in order to be able to do anything. I have tables that don't have primary keys and I don't want to ever have them. I've normalized my DB and it's the best way to keep track of multiple items for a single person.
you have been nominated for dbdebunk quote of the week. congratulations!
I bought several (pre-opteron) Athlon systems that had some serious problems. There were several high profile bugs such as IDE data corruption if you happend to be using a Creative Labs sound card at the same time (oops!). I love AMD and I'll always buy AMD chips, but I'm ruined on Via for good. OTOH, my current nVidia nForce4 is an awesome system with zero problems. I know one case != trend, but this will probably be echoed by several others.
- Never use a three tier model when developing client/server apps. This only creates redundancy and gets in the way of solving the problem
- When linking to a database always use vendor specific extensions and avoid a database layer using something like odbc. It makes use of the advanced feature set by the particular RDBMS
umm, it sounds to me like you are one of legions of 'application level' programmers. the separation of an application into 'tiers' (which have no real formal definition) just obscures data contraints into a maze of levels of code. Totally unnecessary...the closer your constraints are to the actual data the cleaner and more maintainalbe your application will be.
Very few applications need to be portable across databases. If you pick a good database (PostgreSQL), there is little reason to port. Application languages (ruby, c++, COBOL, Java, etc etc etc) are a dime a dozen and will be switched and/or mixed a dozen times over the lifetime of a enterprise app.
However, it would be horable for our economy. As they start to give away anti-virus/spy-ware software, that eliminates a multibillion dollar industry. That is a problem, but not MS's problem. Its a free market issue, and the market will adjust.
fallacy of the broken window. If what you said was really true, we should be paying people to write worms and viruses because it creates all that business when in fact it just diverts resources from more productive things.
great. Microsoft to deprecate t-sql for C# stored procedures. As a bonus they encourage you to not write orr understand SQL at all, well visual studio writes it for you. Well guess what, they want to obscure and redefine what a database is and what it is supposed to be. t-sql is a great language, queries are first class and it is designed from top to bottom to perform quickly and well.
What problem are they trying to solve...I'll tell you what. SQL works well and is defiened by a standards committe outside their control...why don't we all do everything in vb instead. I betcha one of the reasons it took so long to get out was they couldn't make it run anywhere as fast as 2000 without tons of tweaking.
wrong. the issue here is that for a 'underground hacker' rootkit, if bllzzard finds a way to detect the rootkit, they can safely ban that account. Fear of banning is a pretty good deterrent for hackers. On the other hand, bliz can't very well ban you for running sony's drm now, can they?
Microsoft is finally going to be POSIX compliant. This means it will be eaiser to port unix apps to the MS platform. This is a good thing guys, and heres why:
When you are considering deploying Linux in your business, you first need to make sure your entire toolchain is platform independent. You move all your stuff to open source apps which historically have spotty support on windows, and then just swap out the o/s. Better POSIX support means this proces is eaiser (it also means more options for win32 admins as well, so it's good all around).
I'm a PostgreSQL fanboy, but I hope these guys pull it off. A lot of poeple don't realize that what's good for one open source project is good for all of us (historical emotional baggage aside).
The 5.0 release looks to be the biggest in the history of the database. I say good luck to them. Has anybody played around with their functions implmentations?
If you are interested from managing this from a database you should check out my good friend Magnus's work with integrating openLADP and postgresql via dblink. Check his blog
Afilias runs the.org domain on PostgreSQL. It has been pretty smooth, no matter what the article says, and it was a huge embarassment for Oracle who ran a huge disinformation campaign against PostgreSQL and open source in general.
to author:
please post the benchmarks for the C version of your alogorithm along with the assembly version. It would be nice to know how much difference your tuning made.
I don't understand this at all. How can people take this crap seriously? That's like having McDonald's sponsor a study on the overall health value of its food. Are there actually people so monumentally STUPID in this world that they would believe a study sponsored by an organization with a vested interest in a certain outcome? We must find these people and run them down like animals before they breed!
Consider the alternative: Microsoft pronounces Windows to be valueless and useless!
"We are already running Linux", confirms Microsoft Exec. We are just selling Windows because the world is full off assholes stupid enough to buy it!
Slashdot Mirror
I think you will find if that you do the simple mechanism of preparing statements, postgresql queries are just as fast even if in the form of 'select a,b,c from t where k' type queries. if you don't believe me, try it yourself. the speed advantage of mysql is highly overated.
mysql is *not faster than postgresql, even with myisam tables. postgresql has a much smarter query analyzer and on a query to query level is on par with mysql *if* you prepare the statement first. this wasn't true in the 7.x days, but it is true today.
we bought coraid devices, and they are AoE is much simpler (read: cheaper) than iSCSI. when using jumbo frame switches/cards, we were able to get transfer rates very near theoritical limits on gigibit links, something I have never seen on iSCSI or fc for that matter.
the only thing that bothers me about AoE is there is only a single vendor supporting it at the moment. other than that, it is great stuff. while it is not routable in the sense ip is routable, you can do creative things with ethernet switches and vlan basically giving san like functionality at a fraction of the cost. no longer do you have to keep dual fc/cat6 infrastructure in your server farm.
it's cheap, and if/when it supports bonding lines, well beat fc in performance (comparing two gigabit fc vs/ bonded gigabit ethernet).
merlin
first rule of database programming: never trust the application. It is easy (even trivial) to do constraint checking on the database that is absoltely infallable. It is much easier to secure a database than an appliation in fact. The problem is that people focus security in the wrong place, the application.
holy cow that was funny.
.conf file.
anyways, pg 8.2 will is going to have pg_hba implemented as a table inside the databse instead of
I bought several (pre-opteron) Athlon systems that had some serious problems. There were several high profile bugs such as IDE data corruption if you happend to be using a Creative Labs sound card at the same time (oops!). I love AMD and I'll always buy AMD chips, but I'm ruined on Via for good. OTOH, my current nVidia nForce4 is an awesome system with zero problems. I know one case != trend, but this will probably be echoed by several others.
umm, it sounds to me like you are one of legions of 'application level' programmers. the separation of an application into 'tiers' (which have no real formal definition) just obscures data contraints into a maze of levels of code. Totally unnecessary...the closer your constraints are to the actual data the cleaner and more maintainalbe your application will be.
Very few applications need to be portable across databases. If you pick a good database (PostgreSQL), there is little reason to port. Application languages (ruby, c++, COBOL, Java, etc etc etc) are a dime a dozen and will be switched and/or mixed a dozen times over the lifetime of a enterprise app.
Just rename your emailed copy of the lawsuit to $sys$lawsuit.pdf and it will disappear!
fallacy of the broken window.
If what you said was really true, we should be paying people to write worms and viruses because it creates all that business when in fact it just diverts resources from more productive things.
Merlin
great. Microsoft to deprecate t-sql for C# stored procedures. As a bonus they encourage you to not write orr understand SQL at all, well visual studio writes it for you. Well guess what, they want to obscure and redefine what a database is and what it is supposed to be. t-sql is a great language, queries are first class and it is designed from top to bottom to perform quickly and well.
What problem are they trying to solve...I'll tell you what. SQL works well and is defiened by a standards committe outside their control...why don't we all do everything in vb instead. I betcha one of the reasons it took so long to get out was they couldn't make it run anywhere as fast as 2000 without tons of tweaking.
wrong. the issue here is that for a 'underground hacker' rootkit, if bllzzard finds a way to detect the rootkit, they can safely ban that account. Fear of banning is a pretty good deterrent for hackers. On the other hand, bliz can't very well ban you for running sony's drm now, can they?
Merlin
now can they speed up the pace of the workday?
Merlin
Microsoft is finally going to be POSIX compliant. This means it will be eaiser to port unix apps to the MS platform. This is a good thing guys, and heres why:
When you are considering deploying Linux in your business, you first need to make sure your entire toolchain is platform independent. You move all your stuff to open source apps which historically have spotty support on windows, and then just swap out the o/s. Better POSIX support means this proces is eaiser (it also means more options for win32 admins as well, so it's good all around).
Merlin
I'm a PostgreSQL fanboy, but I hope these guys pull it off. A lot of poeple don't realize that what's good for one open source project is good for all of us (historical emotional baggage aside).
The 5.0 release looks to be the biggest in the history of the database. I say good luck to them. Has anybody played around with their functions implmentations?
So, google is carving up your cash cow for stakes. No problem, you have all those fat xbox revenues to send your kids to college...oop!
If you are interested from managing this from a database you should check out my good friend Magnus's work with integrating openLADP and postgresql via dblink.
Check his blog
This is a reveiw of Dungeon Siege I. DSII is only mentioned in passing. I mean, come on! :)
Afilias runs the .org domain on PostgreSQL. It has been pretty smooth, no matter what the article says, and it was a huge embarassment for Oracle who ran a huge disinformation campaign against PostgreSQL and open source in general.
Merlin
Making headlines:
Cold fusion solved!
Microsoft opens sources Windows (You were right all along!)
Cold snap in Hell, everything frozen over!
to author:
please post the benchmarks for the C version of your alogorithm along with the assembly version. It would be nice to know how much difference your tuning made.
Merlin
how about the proof that girls are evil?
Merlin
7.5 will contain a native windows port with no external dependencies. You can find the current binary version here.
Even though it is currently in beta it works very well. The port is now being downloaded over 2000 times a week and increasing all the time.
They got generics working in a very short time, this was quite an achievement.
Mono is a sophisticated development platform, and it will provide a easy transition route away from Microsoft technologies
I don't understand this at all. How can people take this crap seriously? That's like having McDonald's sponsor a study on the overall health value of its food. Are there actually people so monumentally STUPID in this world that they would believe a study sponsored by an organization with a vested interest in a certain outcome? We must find these people and run them down like animals before they breed!
Consider the alternative:
Microsoft pronounces Windows to be valueless and useless!
"We are already running Linux", confirms Microsoft Exec. We are just selling Windows because the world is full off assholes stupid enough to buy it!
Merlin