| |
| |
| |
|
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
Comments:
<0> hehe, here we go ;)
<0> Yep, that did it
<0> ;)
<1> groovey
<2> any one can help?
<2> why does the mysql php admin show the values of the fields like [BLOB - 5 Bytes]
<2> and not the value
<2> ?
<1> i believe i already answered that question satlan32 :P
<2> andrewbryson - i don't see the answer sorry :S
<2> andrewbryson - you mean this: i believe the general consensus is that it is not a very good database client but i have never used it myself so could not say one way or the other?
<3> does anyone know why changing ft_min_word_len would have no effect...?
<1> that would be the one :P
<2> andrewbryson - so it's only because of the client..
<4> how about +c on the channel?
<5> satlan32: scripts like those are extremely annoying and rather stupid
<2> Darien_ - so any other GUI for the MYSQL?
<2> Darien_ - i tried DBDesigner 4
<2> Darien_ - but i can't make iot work
<5> satlan32: http://cairo.darien.ca/~dan/idiot.png
<4> satlan32: http://www.datanamic.com/dezign/index.html ?
<4> Darien_: same here :)
<4> that's why i asked for +c
<6> strip colors
<5> yeh
<2> Darien_ - what is this dariaen
<5> satlan32: I CAN'T ****ING READ WHAT YOU'RE SAYING
<5> did you even click that URL I gave you?
<2> Darien_ - yes. i can't open png files
<5> wtf
<4> satlan32: Darien_ just gave you the link to an image of his irc client
<4> satlan32: black on black isn't quite readable
<5> IDIOT!
<4> Darien_: make it a jpg :)
<6> :D
<4> Darien_: he can't read png files :)
<2> i see the problwem.
<5> then he's even more useless than I thought
<4> satlan32: here we go :)
<5> http://cairo.darien.ca/~dan/idiot.jpg
<4> Darien_: lol
<2> well i don't know why you can't see what i'm writing...
<4> because our backgrounds are black
<5> and your text is black
<4> and your client sets the foreground to black, but not the background to white
<2> your text is black also
<5> no
<5> our text is nothing
<5> your client decides what color to make it
<5> but your client is saying 'make this text black'
<2> no is ok?
<5> yes
<2> ok
<5> this is why people who don't understand IRC shouldn't use crappy ****ty scripts
<2> so what client you sugest?
<4> irssi!
<5> stock mIRC, pIRCh, or anything else without a script that uglifies your text
<4> or mIRC, but without the MULEz SCRIPT
<5> yeah
<5> stock
<2> i mean for the MYSQL
<2> :)
<5> I dunno, I don't know what you want because I couldn't read any of your text
<2> why does the mysql php admin show the values of the fields like [BLOB - 5 Bytes]
<5> because it's binary data that phpMyAdmin doesn't know what to do with
<2> in phpmyadmin?
<5> and it could be very large
<2> it used to show me the values, but somehow it changed
<5> check the preferences then
<5> or ask in #phpmyadmin
<2> i asked... no one is there...
<7> SELECT *, IF(col=1, col2, col3) AS foo FROM largeTable LIMIT someOffset,20 ORDER BY foo; Is it posiible to optimize this query ?
<7> the problem is that ORDER BY scans entire table
<2> ok i'll keep looking
<2> thanks
<7> on virtual column
<5> zimnyx: don't use *
<7> Darien_: i must, i need all data
<5> zimnyx: just because you need all data doesn't mean you must use *
<5> you can specify the columns individually
<7> Darien_: would listing all columns help? how?
<5> zimnyx: it wouldn't speed things up, but it would mean you'
<5> you're not doing something that everyone frowns on
<5> which can help you down the road when you modify your code or table
<7> Darien_: i use php's DataObject to make sure if all columns are in their place
<5> one thing you could possibly do is use a union
<5> instead of having that IF in there, you UNION two SELECT queries, one for col=1, and one for col!=1
<0> I need to transpose some dates into a second column. The date column that has the right data expresses it as '27 Nov 2003' for example. I need this to look like: '2003-11-27 00:00:00'. How can I do this at the mysql shell?
<5> but I don't think that would be especially faster necessarily
<7> Darien_: i'm only talking about optimizing ORDER BY on virtual column.
<5> yes, I know what you're talking about
<5> !m setuid date_format
<7> to use some indexes.. i guess it's impossible, but i;m not an expert
<8> setuid: (Date and Time Functions) : http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
<5> zimnyx: MySQL is going to do a table scan anyway, regardless of how you try to optimise
<5> well, maybe not...
<5> yeah, I think it will, because it has to process every row before it can do the ORDER BY
<7> Darien: if it wasn;t wirtual column i could index it. but than data would be redundant (addintional column)
<5> what exactly are you trying to do here?
<7> and then use ORDEER BY on indexed column
<7> Force mysql to use index to remove table scan when order by
<5> no
<7> query takes 0.5 sec
<5> what are you trying to do?
<7> to speed up.
<5> no ****
<7> 0.5 sec/query is much too much
<5> can you be less specific?
<5> what is this query for?
<7> it's used on webpage
<0> Looks like I need to wrap a little php around this, query and update
<7> for browsing all customers of company
<5> ok, can you be MORE specific now?
<5> explain what this query is for and what it is meant to accomplish
<5> or just stop talking
<9> couln't have said it better..
<0> zimnyx, premature optimization is bad
<5> it's not premature, his query is just idiotic :/
<7> i display all customers (20 per page) with prev/next button.
<5> ok
<7> i got 16.000
<7> custmers
<5> right
<9> congrats..
<7> it will be removed, couse browsing 16000 by 20 is stupid
<7> but i was curious if it is possible to speed it up
<5> wait
<5> all you're doing is paginating?
<5> what is the IF for?
<5> because that's what's slowing you down
<7> I got columns: firstName, lastName, companyName, customerType: IF(c.type = 'company', c.companyName, c.lastName) AS _lastNameOrCompany
<7> i need sorting by name, but name depends on customer type
<5> !man union
<8> (UNION Syntax) : http://dev.mysql.com/doc/mysql/en/UNION.html
<5> ok, well
<7> What is purpose of union there? to separate company and no-company, but in the end i need to ORDER BY whole UNION because company names and lastNames will be displayed together
<5> the purpose would be so that you're not pulling 16k rows
<5> but the problem becomes pagination
<5> honestly, I think you need to re-engineer how it's handled
<7> i agree
<7> The easiest solution is storing lastName and companyName in one column called 'name'.
<7> customerType would tell what type of name is stored there
<7> when i could index column name and ORDER BY on it.
<7> How do you think?
<5> I think that's probably the most efficient way to do it
<7> :)
<7> Thanks for your voice
<10> i've been googling, but does anyone know the cause for "Got timeout reading communication packets" in my error log?
<11> hi, wich join (or whatever) i have to choose if i want to query a m-to-m relationship?
<12> Can someone please ***ist.. how do I check/change the root mysql p***?
<12> (or reset)
Return to
#mysql
or
Go to some related
logs:
#perl
#perl
#perl
ox0000
Modification of non-creatable array value attempted, subscript -1
conkyrc cpufreq
#linux
ubuntu wpa prism belkin
firefox aoss gentoo
#web
|
|
