Actually, on any DB it's better to create the index after the fact if possible for a simple reason. The most common index is a B-tree, and creating it after the fact leaves you with a perfectly balanced tree. Creating it while loading data requires a lookup for every row, which takes much longer, and it also results in an unbalanced tree, so your queries will not be as efficient. In my initial attempt using MySQL, I actually did create the index ahead of time, but the time required to load the data was much too long. I researched this issue quite a bit, and found this article, which echoed the sentiments of many, indicating that it's much more efficient to create the index after the fact.
This seemed like it would work but lead me to the previously described problem. I would also like to add that the company I work for does use MySQL in certain instances with tables over 100 million rows; however, these databases are maintained by a third-party company specializing in the application, and even they wrestle with corruption quite frequently. I've used MySQL quite a bit in the past, and I'm not saying it's impossible to use with large amounts of data. I'm saying it's a PAIN, and out of the box Postgres is much easier to work with and much easier to maintain. Anyway, this is just my experience, so take it FWIW. BTW, it's pretty obvious that you're trolling at this point, so I'm only responding for the benefit of those who might actually be interested in doing this for a living in the "real world".
This was a comparison I conducted on my own using the latest stable releases of MySQL and PostgreSQL. I posted them to refute the article, which IMO was very flawed.
I had to make a decision recently between Mysql and Postgresql for a database composed of many tables with greater than 50,000,000 rows. While going through the decision making process, I loaded a sample table with 50,000,000 rows to do some benchmarks. The first thing I had to do to run my tests was index the table. I started with Mysql using a InnoDB table type. I had both database servers relatively tuned to the hardware they were running on. I ran the create index with MySQL and detached my screen session. I came back several hours later to find MySQL was doing something along the lines of INDEX via REPAIR SORT. After some reading, I learned that this takes an order of magnitude longer than building an index the "normal" way and is caused by the index becoming corrupted during the creation. Okay... so, I restarted this process several times and encountered the same problem. This is clean data mind you that has already been exported from an existing SQL server. I duplicated my install on a second server and had the same problems. Very annoyed with MySQL, I gave Postgres a try. It worked on the first time in less than 25 minutes without issue. Since then I've been using it on 250,000,000 row datasets without issue. It's always reliable, and as long as you remember to use CURSORS for huge SELECT statement, it's painless to work with.
I agree with most of what you said; however, any self-respecting Postgresql or Mysql installation definitely needs to be tuned to run decently. Postgresql in particular has the most conservative default configurations of any SQL server I know of. That being said, once it's tuned, the sky is the limit. SQL Server auto-tunes, which can save some time with initial setup, but it's caused me far more grief than Postgresql in daily use, and yes, I use both daily.
Kienbock's disease is much worse and believed to be caused by repeptitive micro-trauma (aka typing). An orthopedic doctor thought that I might have it, but I was very lucky, and it ended up just being an occult (hidden) ganglion cyst. Basically a bone in your wrist dies from lack of blood supply, and it hurts to turn doorknobs, pickup small objects, and do... well just about anything. So, use proper hand position when typing, and don't overdo it!
Why not just fix the bug and then recreate the rankings index? Googlebot hits my sites all the time, so I know that it covers the rest of the internet quite often as well. With their amount of hardware, it probably wouldn't take long.
This analysis is relatively shortsighted considering that there are many many factors beyond device drivers influencing people to use Linux. I would say that freedom from proprietary protocols and file formats is a major factor, and that's something Redmond will never have.
I just installed Fedora. Can someone tell me the difference between using Yum and the RedHat Update Network? It seems to me that the Gnome applet uses the update network, and I thought you had to pay to access it. Sorry for the offtopic question, but I've been wondering about this for a while.
To me, UnixWare is like a horrible car accident. I don't want to look because I know it's going to be bad, but the perverted side of me just can't resist. Anyway, here's an OSNews review of a recent release of UnixWare (just in case you have a kinky side).
For anybody running Panther, here is a set of indespensible tips. I go through the steps outlined in that article about once a month, and it keeps my G4 laptop purring like a kitten. The steps about regenerating the prelink binding are especially relevant to performance.
You can use xrandr to change your resolution on the fly without having to close any applications. For remote access without closing applications, something like VNC might be of help, but I know that's not exactly what you're looking for. I don't know of any way to detach a GUI app running locally and reattach to a remote host on any OS, but I'm sure it's possible.
Gripe 3: If X is such a truly network independent application why the hell can't I simply redirect the output of an already running process to any X-term?
You can easily do this if you use screen. I do it all the time.
http://www.guckes.net/screen/
Use it like this:
user@host:~$ screen -S longcompile
user@host:~$ make
Now press ctrl-a then d to detach.
Close all your terms and go home.
Now ssh back into the machine and type screen -R longcompile
to reconnect to your compile session. You can detach and reattach as often as you like. It also has a lot more features, but I'll let you RTM for those.
I'm a long time Linux user who's just about to purchase my first Mac, a G4 powerbook. I use Linux on the desktop everyday, and while I like it, I'm not afraid to admit that compared to an OSX desktop, it lacks polish. I don't blame X, Gnome, KDE, or anyone for this. I really believe it's simply a matter of Mac development being more focused due to Apple spearheading it's development.
Linux is awesome because it's affordable to everyone, and it's become a very nice alternative to Windows; however, I don't think that it's going to steal a significant number of users from the Mac market since OSX has a major geek appeal as well.
It's silly to think that users have to be either here or there. I plan to continue to use both Linux and OSX after the purchase of my laptop, and I don't understand why everyone is so black and white about what you run on your desktop. Anybody that's used a Mac knows what the appeal is about. Linux has a natural attraction to anybody that wants a stable and cost effective OS. Why not enjoy both?
This is a really neat idea, and it's a long time coming; however, I wouldn't expect overly divergent results among Linux distributions. Afterall, they're all going to use the latest 2.4 and 2.6 kernel and comparable glibc versions(with maybe the exception of Debian), so the only speed difference should be in the compiler flags used to build the packages. I'm not trying to negate the coolness of this competition because it should give a good measure of performance between the BSD distros VS Linux distros, but don't be surprised when the Linux distros all show comparable results. As a footnote, I do expect Gentoo to come in the lead of the Linux distros having tried them all and found it the fastest in empircal testing...
I've never used FreeBSD, so I'm a little confused by this post. I currently use Gentoo, and KDE alone takes about 8 hours to compile on my machine. Are you installing all this from binary or something?
The DMCA is unconstitutional, anti-competitive, anti-innovative, and anti-american; however, after a careful perusal, I can't find anything inherently homosexual or happy about the law. Maybe you can enlighten me.
Slashdot Mirror
Actually, on any DB it's better to create the index after the fact if possible for a simple reason. The most common index is a B-tree, and creating it after the fact leaves you with a perfectly balanced tree. Creating it while loading data requires a lookup for every row, which takes much longer, and it also results in an unbalanced tree, so your queries will not be as efficient. In my initial attempt using MySQL, I actually did create the index ahead of time, but the time required to load the data was much too long. I researched this issue quite a bit, and found this article, which echoed the sentiments of many, indicating that it's much more efficient to create the index after the fact.
o n-part-1/6/
http://www.devshed.com/c/a/MySQL/MySQL-Optimizati
This seemed like it would work but lead me to the previously described problem. I would also like to add that the company I work for does use MySQL in certain instances with tables over 100 million rows; however, these databases are maintained by a third-party company specializing in the application, and even they wrestle with corruption quite frequently. I've used MySQL quite a bit in the past, and I'm not saying it's impossible to use with large amounts of data. I'm saying it's a PAIN, and out of the box Postgres is much easier to work with and much easier to maintain. Anyway, this is just my experience, so take it FWIW. BTW, it's pretty obvious that you're trolling at this point, so I'm only responding for the benefit of those who might actually be interested in doing this for a living in the "real world".
This was a comparison I conducted on my own using the latest stable releases of MySQL and PostgreSQL. I posted them to refute the article, which IMO was very flawed.
I had to make a decision recently between Mysql and Postgresql for a database composed of many tables with greater than 50,000,000 rows. While going through the decision making process, I loaded a sample table with 50,000,000 rows to do some benchmarks. The first thing I had to do to run my tests was index the table. I started with Mysql using a InnoDB table type. I had both database servers relatively tuned to the hardware they were running on. I ran the create index with MySQL and detached my screen session. I came back several hours later to find MySQL was doing something along the lines of INDEX via REPAIR SORT. After some reading, I learned that this takes an order of magnitude longer than building an index the "normal" way and is caused by the index becoming corrupted during the creation. Okay... so, I restarted this process several times and encountered the same problem. This is clean data mind you that has already been exported from an existing SQL server. I duplicated my install on a second server and had the same problems. Very annoyed with MySQL, I gave Postgres a try. It worked on the first time in less than 25 minutes without issue. Since then I've been using it on 250,000,000 row datasets without issue. It's always reliable, and as long as you remember to use CURSORS for huge SELECT statement, it's painless to work with.
I agree with most of what you said; however, any self-respecting Postgresql or Mysql installation definitely needs to be tuned to run decently. Postgresql in particular has the most conservative default configurations of any SQL server I know of. That being said, once it's tuned, the sky is the limit. SQL Server auto-tunes, which can save some time with initial setup, but it's caused me far more grief than Postgresql in daily use, and yes, I use both daily.
You all can figure out what 'pico' doesn't stand for.
PIne's message COmposition editor.
Kienbock's disease is much worse and believed to be caused by repeptitive micro-trauma (aka typing). An orthopedic doctor thought that I might have it, but I was very lucky, and it ended up just being an occult (hidden) ganglion cyst. Basically a bone in your wrist dies from lack of blood supply, and it hurts to turn doorknobs, pickup small objects, and do... well just about anything. So, use proper hand position when typing, and don't overdo it!
http://tinyurl.com/4aanx
Why not just fix the bug and then recreate the rankings index? Googlebot hits my sites all the time, so I know that it covers the rest of the internet quite often as well. With their amount of hardware, it probably wouldn't take long.
This analysis is relatively shortsighted considering that there are many many factors beyond device drivers influencing people to use Linux. I would say that freedom from proprietary protocols and file formats is a major factor, and that's something Redmond will never have.
I just installed Fedora. Can someone tell me the difference between using Yum and the RedHat Update Network? It seems to me that the Gnome applet uses the update network, and I thought you had to pay to access it. Sorry for the offtopic question, but I've been wondering about this for a while.
If only someone would tell the guy that writes cdrecord that he could get his own domain name.
y ee s/joerg.schilling/private/cdrecord.html
http://www.fokus.gmd.de/research/cc/glone/emplo
Looks like the system is still bugged out. Hopefully it will be fixed soon.
I get grey hair just thinking about Windows. Is that in the knowledge base?
To me, UnixWare is like a horrible car accident. I don't want to look because I know it's going to be bad, but the perverted side of me just can't resist. Anyway, here's an OSNews review of a recent release of UnixWare (just in case you have a kinky side).
UnixWare 7.1.3 Review
I googled for Real Media Burner, but I can't find it? Can you give me the link?
Uh... did you read my post? I have a laptop which means it's not up 24/7 like my desktops are.
For anybody running Panther, here is a set of indespensible tips. I go through the steps outlined in that article about once a month, and it keeps my G4 laptop purring like a kitten. The steps about regenerating the prelink binding are especially relevant to performance.
You can use xrandr to change your resolution on the fly without having to close any applications. For remote access without closing applications, something like VNC might be of help, but I know that's not exactly what you're looking for. I don't know of any way to detach a GUI app running locally and reattach to a remote host on any OS, but I'm sure it's possible.
Gripe 3: If X is such a truly network independent application why the hell can't I simply redirect the output of an already running process to any X-term?
You can easily do this if you use screen. I do it all the time.
http://www.guckes.net/screen/
Use it like this:
user@host:~$ screen -S longcompile
user@host:~$ make
Now press ctrl-a then d to detach.
Close all your terms and go home.
Now ssh back into the machine and type screen -R longcompile to reconnect to your compile session. You can detach and reattach as often as you like. It also has a lot more features, but I'll let you RTM for those.
I'm a long time Linux user who's just about to purchase my first Mac, a G4 powerbook. I use Linux on the desktop everyday, and while I like it, I'm not afraid to admit that compared to an OSX desktop, it lacks polish. I don't blame X, Gnome, KDE, or anyone for this. I really believe it's simply a matter of Mac development being more focused due to Apple spearheading it's development.
Linux is awesome because it's affordable to everyone, and it's become a very nice alternative to Windows; however, I don't think that it's going to steal a significant number of users from the Mac market since OSX has a major geek appeal as well.
It's silly to think that users have to be either here or there. I plan to continue to use both Linux and OSX after the purchase of my laptop, and I don't understand why everyone is so black and white about what you run on your desktop. Anybody that's used a Mac knows what the appeal is about. Linux has a natural attraction to anybody that wants a stable and cost effective OS. Why not enjoy both?
Don't they know that it's MozillaFirefox and not MozillaFirebird. This installer obviously isn't going to be able to keep up to date.
This is a really neat idea, and it's a long time coming; however, I wouldn't expect overly divergent results among Linux distributions. Afterall, they're all going to use the latest 2.4 and 2.6 kernel and comparable glibc versions(with maybe the exception of Debian), so the only speed difference should be in the compiler flags used to build the packages. I'm not trying to negate the coolness of this competition because it should give a good measure of performance between the BSD distros VS Linux distros, but don't be surprised when the Linux distros all show comparable results. As a footnote, I do expect Gentoo to come in the lead of the Linux distros having tried them all and found it the fastest in empircal testing...
Science has come up with a new way to cut the cheese.
I've never used FreeBSD, so I'm a little confused by this post. I currently use Gentoo, and KDE alone takes about 8 hours to compile on my machine. Are you installing all this from binary or something?
The DMCA is unconstitutional, anti-competitive, anti-innovative, and anti-american; however, after a careful perusal, I can't find anything inherently homosexual or happy about the law. Maybe you can enlighten me.
(Score:-1, Homophobic)
http://www.towersofhanoi.org