| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
Comments:
<0> I'd be running linux now if I could get my damn wireless card settings to save correctly in ndiswrapper.. but they just will not save..
<1> My car gets me places, it isn't something I jack up in my garage and dissect on the weekends.
<2> I agree
<1> Similarly, my computer is what I use to get work done.
<2> I don't have that much spare time to messa round with compilers.
<2> I do, though, just not for every package I need
<3> I'm not saying that its BAD to use something with dependancy handling.
<0> and as for gentoo, that took 13 hours to install on a stage 3 tarball :|
<3> another reason I dislike it is that if you compile a library from source instead of by hand you have to add the dependancys to the repitore.
<4> once compiled KDE @ Cygwin
<4> took like 24 hours :p
<4> I mean @ colinux
<4> ;p
<5> how in the hell would a php sort be faster then a SQL sort
<6> indexed the SQL table?
<3> kaber, poorly optimized sql database?
<0> night all
<6> your DB machine is worse than the webserver? your sort's part of a WHERE on a non-indexed join or something?
<3> sonofa....
<5> yea. i thought that too, but this guy asking me weird question
<7> db server swapping?
<6> he's delusional and hasn't actually measured it? he's using a crap DBMS? the DBMS is running enormous triggers during your select? in other words, there are lots of ways it could happen
<5> hmm
<3> hmm
<3> shower time!
<8> hi all
<9> i did 5 mins on the treadmill and i'm tired already
<8> I'm searching for a free command line tool to indent php files ( like indent but for php )
<7> vim?
<10> ne0futur: have you tried your tab key?
<7> v1G=
<8> Gimp_: have you tried indent on C code ?
<10> ne0futur: i indent when i code it. i don't need a script to do it for me.
<7> ne0futur: i think he was implying to indent as it was.... yeah like he said
<8> and you never get code you didn't write yourself ? never need to verify indent before checkin ?
<7> ne0futur: do you have vim or emacs (mabey)?
<6> php code formatter gives a few options on google
<8> yes I use vim but I would really prefer a command line tool like indent
<6> lemme know if any of them are good, I could use one myself actually
<8> vim has a "reindent this file" tool ?
<8> I want to be able to specify indenting options the same way as unix indent command line
<7> through it in vim type: 1GvG<enter>
<11> hmm
<11> neofuture...
<7> thow*
<11> that name sounds very familiar
<11> from like.. 5 years ago
<11> cant remember from where though
<7> it depends on how vim was installed, but a standard install should have the indentation
<7> there could be other, more indent'ish, like apps, perhaps sourceforge might have something
<8> Modulus: you're in france ?
<11> no
<7> or feeling lucky with 'indent php'
<8> so it probably was on IRC ;)
<11> hmm
<12> Executed in 0.00961089134216 seconds, using 14 queries
<11> what channels
<11> do you frequent
<12> 14 =/. Is that a lot?
<8> zircu: yes i'll try sourceforge
<8> Modulus /msg nickserv info neofutur should tell you my chans
<11> u message me :D
<6> rixth: It Depends
<7> rixth: it seems reasonable, but the question is will it perform under load
<6> if they're just a bunch of selects on indexed tables, who cares, they're probably hitting the query cache
<7> i still would wonder why you have 14?
<12> Xyphoid, zircu it's a toned down myspace (very toned down). Most of them are selects, yeah
<13> Number of queries doesn't matter.
<13> It's how long they take.
<7> one for the db session, one for authentication, a couple to get data, one to show a result set
<7> still 14? in one page request?
<6> i have seen a CMS that did 800 per page.
<13> I've seen 20x that.
<12> zircu, well, for one, I have 3 tables (audio, video and images) all a/v/i from the site go into that one table, but ratings for all media types and the number of comments etc are all held in one table.
<13> There are 100 things you should be concerned about before number of queries. I'd be happy and move on.
<12> Awesome. Yeah, the page execution time looks pretty good anywya.
<12> Should I be worrying about using lock tables when I make an insert?
<13> Using InnoDB or MyISAM?
<13> What's the frequency of the inserts, as well?
<13> Yo mjec
<12> MyISAM.
<13> Nah, that's all done automatically.
<12> Inserts do not happen often. 80% of queries will be selects.
<8> zircu: thanks for the sourceforge idea, I found http://sourceforge.net/projects/wizindent which seems to be interesting ;)
<13> How many inserts are you doing, and are they large?
<13> Inserting big blobs or anything?
<14> I'm looking for the best way to do a validation of sorts using SQL and php in a form that I'm using.......I need to be able to do a SELECT SUM(tix) as num_tix where 'tourdate' = $tourdate and 'tourtime' = $tourtime.......then setup some conditionals that will use num_tix, check it's total and take into account the updated cur_tix value that the user is trying to submit to make sure that a tour doesn't get overbooked....any ideas on the best implementation to
<12> No, I am not storying any binary files. It is all just text, int and varchar fields.
<13> You're fine then. Just do the INSERT
<12> Ok, thanks for the re***urance =)
<13> Problem is-- since MyISAM auto-locks tables, if the INSERT takes a long time, SELECTs (and other queries) start stacking up, waiting for the table to become free again.
<7> inserts on myisam are autmatic yes, but they are 'table' locks.. this is why how much load and traffic is a concern. and as well why it really needs 14 queries
<13> That can bring an app down to a crawl.
<7> it is hard to say without an evaluation on what you are selecting and what Julian|Work was asking, the insert an update frequency
<12> Actually, I'd say 90-95% are selects.
<12> I can find out.
<7> rixth: 5% of 1000 queries in a minute is quite a bit though
<7> for those heavy modified tables you will be best off with innodb, but this more for #mysql
<12> Executed in 0.00934815406799 seconds, using 14 queries (2 inserts, 12 selects)
<12> 16% inserts.
<6> are you selecting from teh same tables you're inserting?
<7> of those 2 inserts when do you select from them?
<15> they have strtotime() but do they have anything like strtodate() sorry but i cant find it!
<15> or does strtotime() support date, that must be it
<7> of those 12 selects when does the data get changed?ed?
<6> if you're just logging things then you're probably not selecting during the same requests
<12> I have to find out what they are first. I have been developing this for a while. I think one of them sets the 'user last logged in' time and the other... I'll find out
<15> 2006-05-31 i wanna convert that into: May 31, 2006
<12> And the other is an insert into the advertisment tracking table (incrementing the number of inserts) UPDATE advertisments SET impressions=impressions+1 WHERE id='2'
<6> if it's a problem you could move the last-login info off the user record, for example, into a logins table
<12> insert/update.
<12> Yeah. You think that would be a good idea? Store user logins, time last logged in etc in a seperate table from the users profile html etc
<7> rixth: it could, the update of the login is going to be your bottleneck most likely, it might be best to have it in innodb format instead of myisam
<13> Yeah, that should be in a separate table.
<12> Yeah, the advertisment (it is only 6-7 varchar fields) and user table (currently about 9 fields) are probably the ones that are most hit
<12> Man, I just made it so I see all queries at the top of the page... I need to optomized this!!! http://72.3.253.116/ Man, that is terrible. Time to optomize!
<12> Advertising uses 8 queries total...
<16> Man
<16> gosh
<6> rixth: i'd have an impressions table and insert into that instead of updating advertisements
<7> rixth: and they dont use any index, so the more ads you have the slower it will get
<6> rixth: but really you should measure this under load before optimising
<12> zircu, what should I be indexing? The url and location of the ad?
<7> oh and the impression shouldn't be in this script but the image serving the image, at leas that is how i would do it
<12> Xyphoid, the advert table only has 14 fields (10 int, 2 enum and 2 varchar)
<12> ints are fast, are they not?
<7> rixth: the odds will be that it wont use indexes since you have that OR and the status = 'active' and likely the 'size' as well
<12> Ah.
<7> rixth: this is getting more and more a #mysql discussion though
<12> Sorry- I'll take it there.
<17> how can i align </div><div> put the next div tag at the bottom without setting width:100%; ?
<17> or can't i?
<7> but php related, why are you updating the imipressions at this page?
<12> Becuase advertisments are being shown
<7> rixth: at least you think
<15> is there anyway to launch an executable on a client machine with their permission, without ActiveX or VBScript
<4> ok I figured out this evil oo system
<12> zircu, well, you see, we use a mix of local ads (the music ones) and ads from a 3rd party. If there are none of ours available for a certain size, it fetches the 3rd party code.
<12> SELECT value FROM misc WHERE field='leaderboard_code' that is what that is.
<6> rixth: updating ints is still an update, though.
<18> anyone here has used smarty php template engine?
<4> I do
<7> rixth: you are just sending the the ad image to the browser directly to its path on the webserver?
<18> do u SinnerG?
<4> yes I do.. otherwise I wouldnt say so ;p
<4> btw: this is my idea for a OO base => http://code.bulix.org/5824
<12> <a href="/adClick.php?id=2"><img src="/advertisments/8c68f8a7321d4d3b64e53c9b2f58ebff.gif" alt="advertisment"></a> yeah.
<18> k, just a quick question :p i f u dont mind
<4> hury
<4> was going to bed :p
<6> anyway, re optimisation, read this: http://www.cs.cmu.edu/~jch/java/rules.html
Return to
#php
or
Go to some related
logs:
#python
|Lord_Zoo|
bash recursive file move for loop
MPT problem gentoo /dev/sda3
#math
#kde
filadoda
#javascript
#sed
java groundy
|
|