"Maybe they'll even use AMD processors, for a change (though I still think that Intel has an ace up their sleeve). Regardless, the next five years should be interesting to watch."
Thank you - that is exactly my point, NOBODY can know every situation and saying that a table with 100 columns is poorly designed is just plain ignorant and wrong.
Yes, my example is wrong for what *you* think I should do with it, but NOT wrong for what I use it for. Again, I don't need the database to check the integrity of anything of me. I won't be adding columns. It's as simple as that. Back to the original point - when somebody says a table with 100 columns is done wrong, they aren't factoring in every possible use for one. Am I using this specific table like a flat file? Yes. There is no rule that says I can't. It doesn't mean the schema doesn't work for the application I apply it to. If I were doing more with this table, you would be correct - but I gave an example of a table with a sole purpose of displaying checkboxes either yes or no, nothing more, nothing less.
"splitting that up into several tables in the same database will offer a significant performance increase."
Again, what don't you understand?? It will NOT give a performance increase by splitting my example into multiple tables, absolutely no way. For the millionth time, I'm getting every column every time. Anybody who says different didn't read my other posts explaining what what I gave as an example.
Ok, people are completely misunderstanding what I was saying - I'm not talking about answers or responses on a quiz. I'm talking about a list of the questions, and whether or not they are completed on a main page. Simple as that. Your way is definitely elegant, but my way is quick and to the point - and my example, the questions don't change - and if it was a one time thing, they would never change. I can't stress enough, the quiz itself is not in the table I gave as an example, JUST the user, and the questions numbers - each question number can have a 1 or a 0 as a value. If I were building the actual quiz table, I would do it similar to how you suggested.
"You DON'T need 100 columns, ever. If you have that many columns you should be breaking the table up into several tables with 1:1 joins. Seriously. There will always be some fields that aren't needed. Make the rows smaller by putting commonly used fields in one table, rarely used rows in the other."
I completely disagree. Breaking up the questionaire into seperate tables does nothing. I want every question every time, it's all one HTML page with checkboxes and links to the questions. If they were seperate tables, I'd just have a lot of joins every time the page loads, which isn't going to help performance. In my example, there are no rarely used rows - all rows are used equally.
"And your example of a questionaire (1 row per answer, one column per question) is not even close to normalised. What happens if there is a new question? you have to alter the schema. what happens if some questions are not answered? you'd have to have nulls, and wasted space."
No, I never said one row per question - I said one row per person - big difference. Also, the default values for the bit columns would be 0, since the questions are not answered. When they get marked as answered, they are changed to 1. No wasted space and every column is relevant in my example. EVERY time I want EVERY column, no exceptions. Yes, if you added a question you'd add a column. And give it a default value of 0, and then run this simple query "Update Questionaire SET NewQuestion = 0" and then you have no nulls, no wasted space.
You could easily do it the way you propose - the only thing is, you now have 100 rows where before you had 1 - which I'm not saying is the wrong way... but either way you're going to have 100 columns or 100 rows. Performance wise, I'm not sure which is better or if it matters.
"If this is your main problem with SQL, then you have other problems as well. Who in their right mind needs a table with 100 columns? If you have 100 columns, you seriously need to normalize your database."
You're kidding, right? I can think of a lot of reasons to have 100 columns, it simply depends on what you're working with - and it is perfectly normalized. Say you had a questionaire on a web form. Let's say it had 100 questions. Let's say you had a checkbox next to each. When the user checked the box, the "bit" field you set up for question number 1 gets set to 1. Same applies to 2, it gets set to 1 from 0. You could have 100 columns, one for each question - one row for each user. I see nothing wrong with that. Sure, there are different ways to do it, but there is nothing wrong with doing it that way. Also, think of a tax form - imagine all the questions for each form. Then imagine having a table for each form. Just because it's a large number doesn't mean it's not normalized - some things are just large to begin with, and you don't want to fracture them too much.
Re:Sorry, I quit FPSs when they wanted me to jump
on
Review: Serious Sam II
·
· Score: 1
Yeah, I'm not saying that:) I'm just saying that do it like real soldiers/killers/etc and hide behind something and shoot, or whatever. Just jumping around and shooting seems a bit unrealistic to me, which I guess goes with the territory in a game called "Unreal Tournament" I think. I'd just enjoy it more if it was more difficult to jump and shoot at the same time, but as other commentors have said, that's part of the fun I guess - learning a new skill with the speed factor.
Re:Sorry, I quit FPSs when they wanted me to jump
on
Review: Serious Sam II
·
· Score: 2, Insightful
Yeah, that's my biggest gripe with games like UT2004 - when I play people who are really good at it, all they do is jump around and shoot at you. It's annoying as hell since I don't like to jump around aimlessly and shoot. Somebody should make a UT clone and remove all jumping while shooting...
Yes, I also noticed problems with the 81.85 drivers. I am no longer able to play Unreal Tournament on my Gefore 6200 TC card like I was before. Granted, it's not the fastest card - but UT played fine before. The new drivers did drastically speed up UT2004 for me, but absolutely killed the original UT. I was surprised by this.
Re:Why are we hiding from the police, daddy?
on
Vim 6.4 Released
·
· Score: 1
So what's wrong with pico or joe? Both very easy to use in my opinion, much more so than VI.
....as you type that on your Pentium IV which dissapates 110W into your room negating the need for you to run your heater.... while I type this on my Athlon 64 3200 90 nano SOI which runs at 27 C under load....
I have a question though - is this true with LCD monitors as well? Every LCD monitor I have defaults to 60Hz so I leave it. I obviously always adjust my CRT displays, but I can't tell a difference with LCD.
I guess you've never put something like this on a car.... they first started selling "bras" for the front of cars - basically black cloth or leather-like covers with holes cut out for the headlights, etc. Then somebody got smart, or not so smart depending on your view, and they then basically shrunk wrapped a plastic coating around the front of the car to protect it from rocks, etc. The problem with the clear stuff is that the sun wears your paint that's not covered faster than the covered, so your can start to tell a major difference in color over time. They gave these the name of "Clear Bra" or as the previous poster typed, "Clearbra".
Right - I realize that. I have a dish like that with dual out, and I have a splitter with 3 TVs hooked up in my house. I have 2 of them each having their own single tuner for normal TV viewing. The 3rd is hooked up to my dual tuner Tivo, which requires 2 lines from the dish - however it's only one DirecTV card, so it shows up as one box - negating the need to run 2 seperate tuners.
My point is: if somebody can come up with a way to use dual tuner on Myth and not require a second DirecTV tuner, I'm in.
Not really, it doesn't if you have DirecTV. Think about it - how would this work? Say you have a DirecTV tuner plugged into your TV - now what? You only have one feed coming in - this means you would need TWO direcTV tuners you'd be paying for to make this work. That seems rather pointless to me. The only reason I have Tivo over Myth is the dual tuner issue. Show me a way to make this work reasonably, and I'll switch in a heartbeat.
I think you're right - but consider this: the new Macs will run windows, and if they wanted to, they could ship both Mac OS and Windows with one of these computers. Dell should be very scared.
I don't think MS Office is the killer app people think it is - for example, there is no real Outlook equiv on the Mac. I know, I know, there is Entourage, but it sucks because it doesn't mimic Windows based Outlook 100%. So, let's just say MS shot themselves in the foot and didn't put out Office for Mac - big deal. I say that because of one app: Open Office, which does open up word and excel docs very well. Apple doesn't need office, they just don't realize it yet.
I can't go with MythTV unfortunately, or else I would in a heartbeat. I have DirecTV and I currently enjoy my dual tuner tivo which is able to record a show while I watch another. I would have to have 2 seperate dtv receivers to do this with myth, and that's just dumb to pay for 2 different boxes for one TV. Trust me, if there was a better way to make it work with DirecTV, I would do it in a second. I have the money, time, and knowledge to build one of these boxes - I just don't want to get rid of DTV.
That's a very well thought out comment, and I agree. One thing I think a little bit differently than you is that even if Apple released an OS for x86 that was competing with M$, they would still be successful. Microsoft can't stop them - people already know it, and while Microsoft might actually have to *gasp* innovate or lower prices to compete, Apple will still definitely have their nitch, and maybe some more.
Yeah, I was just gonna chime in on that one - my Dad was a school administrator for 30 years. Anytime a local city resolution was going to be passed to help pay for school things, people came out and protested like mad, mostly the older farmers who didn't have kids - or if they did, they were long grown up and gone by now. It was always impossible to get things like that passed to help schools, so schools always operated with a very small budget.
The sad thing is, a good education system just doesn't help people with kids - it helps our society as a whole, so I'm not opposed to having slightly higher taxes if the money is used wisely in the school district.
I think the problem here is that you can't change the battery yourself. Try to name a product in the last 15 years that you can't change it yourself - I'm having a hard time coming up with one. Here's a short list of the products in which you can, it just makes sense:
Laptops
Cellphones
Cars
Walkmans & Discmans from the 80's and 90's
Walkie Talkie's
Flashlights
Cordless phones
And I could go on.... and it's no big deal that Apple uses batteries that recharge, I love that they do - but the fact that you can't change them just plain sucks. To this day, I can't figure out why they did that. I still bought one, but I'm dreading the day the battery fails on me. I know there are web pages that describe how to do it myself, but I'm leary about prying apart a $300 device.
No, now you're talking about the real world. Not a fake game. In a game, the programmers have complete control over how people interact with each other because they define the world in which they interact.
Slashdot Mirror
"Maybe they'll even use AMD processors, for a change (though I still think that Intel has an ace up their sleeve). Regardless, the next five years should be interesting to watch."
. aspx?c=us&l=en&cs=04&category_id=6197&first=true&m nf=116&k=
I don't know about use, but they sure sell them!
http://accessories.us.dell.com/sna/productlisting
Thank you - that is exactly my point, NOBODY can know every situation and saying that a table with 100 columns is poorly designed is just plain ignorant and wrong.
Yes, my example is wrong for what *you* think I should do with it, but NOT wrong for what I use it for. Again, I don't need the database to check the integrity of anything of me. I won't be adding columns. It's as simple as that. Back to the original point - when somebody says a table with 100 columns is done wrong, they aren't factoring in every possible use for one. Am I using this specific table like a flat file? Yes. There is no rule that says I can't. It doesn't mean the schema doesn't work for the application I apply it to. If I were doing more with this table, you would be correct - but I gave an example of a table with a sole purpose of displaying checkboxes either yes or no, nothing more, nothing less.
"splitting that up into several tables in the same database will offer a significant performance increase."
Again, what don't you understand?? It will NOT give a performance increase by splitting my example into multiple tables, absolutely no way. For the millionth time, I'm getting every column every time. Anybody who says different didn't read my other posts explaining what what I gave as an example.
Ok, people are completely misunderstanding what I was saying - I'm not talking about answers or responses on a quiz. I'm talking about a list of the questions, and whether or not they are completed on a main page. Simple as that. Your way is definitely elegant, but my way is quick and to the point - and my example, the questions don't change - and if it was a one time thing, they would never change. I can't stress enough, the quiz itself is not in the table I gave as an example, JUST the user, and the questions numbers - each question number can have a 1 or a 0 as a value. If I were building the actual quiz table, I would do it similar to how you suggested.
"You DON'T need 100 columns, ever. If you have that many columns you should be breaking the table up into several tables with 1:1 joins. Seriously. There will always be some fields that aren't needed. Make the rows smaller by putting commonly used fields in one table, rarely used rows in the other."
I completely disagree. Breaking up the questionaire into seperate tables does nothing. I want every question every time, it's all one HTML page with checkboxes and links to the questions. If they were seperate tables, I'd just have a lot of joins every time the page loads, which isn't going to help performance. In my example, there are no rarely used rows - all rows are used equally.
"And your example of a questionaire (1 row per answer, one column per question) is not even close to normalised. What happens if there is a new question? you have to alter the schema. what happens if some questions are not answered? you'd have to have nulls, and wasted space."
No, I never said one row per question - I said one row per person - big difference. Also, the default values for the bit columns would be 0, since the questions are not answered. When they get marked as answered, they are changed to 1. No wasted space and every column is relevant in my example. EVERY time I want EVERY column, no exceptions. Yes, if you added a question you'd add a column. And give it a default value of 0, and then run this simple query "Update Questionaire SET NewQuestion = 0" and then you have no nulls, no wasted space.
You could easily do it the way you propose - the only thing is, you now have 100 rows where before you had 1 - which I'm not saying is the wrong way... but either way you're going to have 100 columns or 100 rows. Performance wise, I'm not sure which is better or if it matters.
"If this is your main problem with SQL, then you have other problems as well. Who in their right mind needs a table with 100 columns? If you have 100 columns, you seriously need to normalize your database."
You're kidding, right? I can think of a lot of reasons to have 100 columns, it simply depends on what you're working with - and it is perfectly normalized. Say you had a questionaire on a web form. Let's say it had 100 questions. Let's say you had a checkbox next to each. When the user checked the box, the "bit" field you set up for question number 1 gets set to 1. Same applies to 2, it gets set to 1 from 0. You could have 100 columns, one for each question - one row for each user. I see nothing wrong with that. Sure, there are different ways to do it, but there is nothing wrong with doing it that way. Also, think of a tax form - imagine all the questions for each form. Then imagine having a table for each form. Just because it's a large number doesn't mean it's not normalized - some things are just large to begin with, and you don't want to fracture them too much.
Yeah, I'm not saying that :) I'm just saying that do it like real soldiers/killers/etc and hide behind something and shoot, or whatever. Just jumping around and shooting seems a bit unrealistic to me, which I guess goes with the territory in a game called "Unreal Tournament" I think. I'd just enjoy it more if it was more difficult to jump and shoot at the same time, but as other commentors have said, that's part of the fun I guess - learning a new skill with the speed factor.
Yeah, that's my biggest gripe with games like UT2004 - when I play people who are really good at it, all they do is jump around and shoot at you. It's annoying as hell since I don't like to jump around aimlessly and shoot. Somebody should make a UT clone and remove all jumping while shooting...
Yes, I also noticed problems with the 81.85 drivers. I am no longer able to play Unreal Tournament on my Gefore 6200 TC card like I was before. Granted, it's not the fastest card - but UT played fine before. The new drivers did drastically speed up UT2004 for me, but absolutely killed the original UT. I was surprised by this.
So what's wrong with pico or joe? Both very easy to use in my opinion, much more so than VI.
....as you type that on your Pentium IV which dissapates 110W into your room negating the need for you to run your heater.... while I type this on my Athlon 64 3200 90 nano SOI which runs at 27 C under load....
I have a question though - is this true with LCD monitors as well? Every LCD monitor I have defaults to 60Hz so I leave it. I obviously always adjust my CRT displays, but I can't tell a difference with LCD.
I guess you've never put something like this on a car.... they first started selling "bras" for the front of cars - basically black cloth or leather-like covers with holes cut out for the headlights, etc. Then somebody got smart, or not so smart depending on your view, and they then basically shrunk wrapped a plastic coating around the front of the car to protect it from rocks, etc. The problem with the clear stuff is that the sun wears your paint that's not covered faster than the covered, so your can start to tell a major difference in color over time. They gave these the name of "Clear Bra" or as the previous poster typed, "Clearbra".
Right - I realize that. I have a dish like that with dual out, and I have a splitter with 3 TVs hooked up in my house. I have 2 of them each having their own single tuner for normal TV viewing. The 3rd is hooked up to my dual tuner Tivo, which requires 2 lines from the dish - however it's only one DirecTV card, so it shows up as one box - negating the need to run 2 seperate tuners.
My point is: if somebody can come up with a way to use dual tuner on Myth and not require a second DirecTV tuner, I'm in.
Not really, it doesn't if you have DirecTV. Think about it - how would this work? Say you have a DirecTV tuner plugged into your TV - now what? You only have one feed coming in - this means you would need TWO direcTV tuners you'd be paying for to make this work. That seems rather pointless to me. The only reason I have Tivo over Myth is the dual tuner issue. Show me a way to make this work reasonably, and I'll switch in a heartbeat.
I think you're right - but consider this: the new Macs will run windows, and if they wanted to, they could ship both Mac OS and Windows with one of these computers. Dell should be very scared.
I don't think MS Office is the killer app people think it is - for example, there is no real Outlook equiv on the Mac. I know, I know, there is Entourage, but it sucks because it doesn't mimic Windows based Outlook 100%. So, let's just say MS shot themselves in the foot and didn't put out Office for Mac - big deal. I say that because of one app: Open Office, which does open up word and excel docs very well. Apple doesn't need office, they just don't realize it yet.
I can't go with MythTV unfortunately, or else I would in a heartbeat. I have DirecTV and I currently enjoy my dual tuner tivo which is able to record a show while I watch another. I would have to have 2 seperate dtv receivers to do this with myth, and that's just dumb to pay for 2 different boxes for one TV. Trust me, if there was a better way to make it work with DirecTV, I would do it in a second. I have the money, time, and knowledge to build one of these boxes - I just don't want to get rid of DTV.
That's a very well thought out comment, and I agree. One thing I think a little bit differently than you is that even if Apple released an OS for x86 that was competing with M$, they would still be successful. Microsoft can't stop them - people already know it, and while Microsoft might actually have to *gasp* innovate or lower prices to compete, Apple will still definitely have their nitch, and maybe some more.
Yeah, I was just gonna chime in on that one - my Dad was a school administrator for 30 years. Anytime a local city resolution was going to be passed to help pay for school things, people came out and protested like mad, mostly the older farmers who didn't have kids - or if they did, they were long grown up and gone by now. It was always impossible to get things like that passed to help schools, so schools always operated with a very small budget.
The sad thing is, a good education system just doesn't help people with kids - it helps our society as a whole, so I'm not opposed to having slightly higher taxes if the money is used wisely in the school district.
- Laptops
- Cellphones
- Cars
- Walkmans & Discmans from the 80's and 90's
- Walkie Talkie's
- Flashlights
- Cordless phones
And I could go on.... and it's no big deal that Apple uses batteries that recharge, I love that they do - but the fact that you can't change them just plain sucks. To this day, I can't figure out why they did that. I still bought one, but I'm dreading the day the battery fails on me. I know there are web pages that describe how to do it myself, but I'm leary about prying apart a $300 device.The word fake just drove the point home more - the game is in a virtual world, where virtual is a synonym for pretend, fake, not real, simulated, etc.
No, now you're talking about the real world. Not a fake game. In a game, the programmers have complete control over how people interact with each other because they define the world in which they interact.