| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Comments:
<0> I think your right that most DB's will scale much better horizontally than vertially/.
<1> see it as a tree
<1> if you have a tree all the same side it's not optimised
<1> but if you push some dataon the left and on the right it keep stable and much more efficient.
<0> Having 50k files that are 2k rows each having 10 columns will be much faster than having a m***ive 1mill row two column table.
<0> Then again, DBs are fast.
<0> Ugh.
<1> i think having a very big fat table would only make thing longer and harder , except if you create 2-3 table with one on one relationnal
<0> Ya.
<1> don't forget than when you query a table to modify, it will lock it to avoid inconsistent change
<1> multiple table is better for multiple access
<0> Good point.
<1> (unless you use innodb that support row locking)
<0> *nod*
<1> since your user will want ot modify their thing (and not waiting to other million user change) having their own table would give them dedicated access to their data and form.
<0> Ya.
<1> the slow speed can come from other user not just because the database server is fetching data and sorting :P
<0> Right.
<1> in fact unless you are a very very very big database application, you will never face the limitation of database server (unless you created a very very bad database structure who fall down after 1k row :P
<0> hehe, been there, done that ;)
<1> really?
<1> i never reach the limit until now
<0> Well, just forgot an index here and there.
<1> or seen it
<0> No I mean, slow tables.
<1> ok
<1> (ok exept from structure error)
<0> Right.
<0> I have a couple of tables, with user permission in them, that are in teh 1mill+ row size, and they're wicked fast.
<0> But it gets very rarely written to.
<0> And just gets lots of selects.
<1> ok
<1> it's more a lookup table
<0> Right.
<2> wrong
<1> anyway with 1M row and transactionnal, you better know what the hell you're doing lol
<0> Welp gotta run to a docs apointment. Thanks for the chat ShadowAway.
<1> u're welcome it helped me revised my reading
<1> i'm studying db only since one week
<1> read like 700 pages on 1k until now
<3> Hi! Ive got background set in a CSS without any repeat, but I'd like the last 50 pixels of that background to keep repeating after it. Possible?
<4> #html
<5> Handa, #css
<4> that too
<5> ****, either one is a better choice than here.
<6> ..and microsoft ****s..
<4> twice
<5> Right.
<7> nobody here?
<6> nope
<7> ahh i see
<4> hahaha, your cservice ID is "codd"
<7> yes, and?
<4> we say "codd" to mean "****" down south
<7> heh
<4> to codd something is to hole it up to your cock so it looks like a dong
<4> s/hole/hold
<4> we're mature in my office.
<8> now?
<8> what about my job ?
<4> your job?
<8> yep, i have done jo
<4> killfr0g: buttsecks?
<8> XPertMailer
<6> wtf is this guy talking about
<4> i think he's high
<4> or romanian
<4> same difference
<8> pff .. lol
<6> 1.codd piece
<6> thumb up
<6> the crutch part of your knickers
<6> eee my boyfriend daz has just sniffed the codd peice of my knickers
<6> whoops
<8> you have done something like this?
<8> you know php ?
<8> pff newbs
<6> he didn't even state his question
<4> yeah, he was a codd piece
<9> rdw: http://img322.imageshack.us/img322/990/ilold1ed3xu.th.jpg
<10> it's only 2:15
<10> gad damn it
<4> killfr0g: lol
<4> nice
<9> my first workout is next thursday :D
<10> now that's funny
<10> rdw you hooker
<4> hehe
<4> 'sup, sahn?
<10> nada
<10> sup with chew
<4> workin'
<4> stinkin' 'cause it's hot in here
<4> i'm sweatin' like a hog
<10> yeah?
<2> but thats cause your plain fat
<4> irzyxel: i'm not fat
<4> i'm built like a brick ****-house
<10> pfft
<10> he's a brick
<10> house
<10> na na na
<10> he's mighty mighty... lettin it all hang out yeah he's a brick
<10> house
<4> lol
<4> you know it
<10> backups start again
<10> this week
<2> http://www.scambia.com/download.php?id=26094&cat=Celebrity&size=15175680
<9> maybe someone can help me out on this, i have 3 tables: videos, customers, and another 'rentals' which links the other 2 tables (using their IDs). i want to find out how many videos a customer has rented, and do it in 1 query.. i'm guessing it needs a join, possibly 2 joins?
<11> Does anyone here run a business where they host clients sites and develop software to provide the sites' functrionality from their own webserver? as in an application rather than each site has its own code
<12> select videos from rentals where customerid='cid';
<12> ahh you got video ids
<12> ok
<12> you can use subqueries
<12> select * from videos where vid in(select vid from rentals where customerid='cid');
<12> something like that
<9> ah mm
<9> ill try that out
<12> are you working on mysql?
<12> suqueries not supported < 4.1
<9> hmm 5 i think not sure, i'm just testing out some stuff
<9> yeah 5
<12> k then it should work
<9> ye but it's a bit more complex because i need fields from 2 tables
<9> but i get the idea
<10> I don't think you can subquery on 4 I thought it was five only
<12> nah you can begining from 4.1
<12> 4.0 doesnt support it though
<12> 5 supports stored procs and triggers
<10> mmm load average 5.05
<12> 4.0 has some date funcs mising either
<10> in php can I subtract on the date function
<10> say I want current -6 months
<12> well i think you can but you might need to define your own function
<10> see like if it were march, it would return -3
<10> vrs 10
<12> i kinda hate date functions so i never memorize date funcs on any programming related lang
<10> ah
<10> well I need to look at mail users that have not logged in in the past 6 months
<10> and remove them from our system
<12> checking php.net
<10> yeah
<10> I'll do that here in a second
<10> just wondering if someone knew off the top of their head
<13> JC^Omega: strtotime("six months ago") should work
<10> thanks cai
<10> mmm 1.6G mail.tar
Return to
#php
or
Go to some related
logs:
pooci
#c++
#teens
#linux
#linuxhelp
#linux
#london
#linuxhelp
#linux
#MissKitten
|
|
