#mysql - Wed 2 May 2007 between 01:14 and 02:01

NY Lost Funds



kimseongAndyGore: depends
test34_perl_contractor, so I should remove all indexes except parts.number
?
kimseongAndyGore: has supposed to be faster for = search, but btree can do range which hash cannot
test34_: try replace like with = first
test34_kimseong, ok
AndyGorekimseong: hash is faster for =search ?
kimseongtest34_: maybe i made a mistake again
test34_: it should be able to use the index drawings.number
AndyGore: by right
AndyGore: theoretically yes
test34_kimseong, the "=" did it
I forgot that I added a column in parts that equals the drawing number
kimseong, back down to .06 seconds! thanks
without a limit for 6000 results with order by
I'll try to stay away from LIKE
Neniffhi
select * from locations where locationid IS NOT IN (select locationparent from locations)
what's wrong there?
You have an error in your SQL syntax;
oh
IS
lol
thanks anyways
seekwillYou're very welcome.
You should write that query as a JOIN.
AndyGorehas anyone tried Zmanda for backups ?
rf234rregfLAST_INSERT_ID() is an interesting function. Didn't know MySQL had that. I don't trust it, though... I'll get my last inserted ID by other means...
Neniffthose means will fail you
LAST_INSERT_ID() within php is foolproof
mysql_insert_id
i think its the same thing
rf234rregfHmm...
I really don't feel comfortable relying on that.
Neniffyoure more likely to fail by checking a duplicate value
if you dont have a distinct row id, you must be 100% sure the data you are checking for to get the row is not duplicated in any other row
then you will fail
rf234rregfYeah... the username is distinct.
Neniffor else you will fail*
if youre using php though

Page: 2 9 16 23 30 37 44 51 58 65 72 

IrcArchive

NY Lost Funds