sangoku

None?? QQ Ok maybe this will help the table will contain more than 1 mil records and 1 row with a timestamp.

You may have noticed that that command is a logical command and that it is in notation of C++ language.... which almost all advanced lang. no longer support(me daydreaming). You could try and just write AND or OR or as the nice guy above me pointed out use the in case statement

Hy i have a bit of a dilemma i have a bit of a dilemma, am making a keyword database and am stuck with few 2 options that i can think of. 1. use a auto increment row together with a crc row which represents the value of the keyword, so all in all 2 int rows and 1 varchar row 2. use just a simple varchar row and reference it. but here is the tricky part: i have make 2 indexes in the first case. One for the crc value and one for the auto increment value. And in other one i need only 1 index which would hit 100%of the time while the first one would have duplicate entries (crc values are not unique) so i would have to post calculate it... My question is which is more smart/faster to use the index on a varchar column or to use 2 int indexes?? Keywords can become pretty long more than 25 chars and can also be small like 4-5 chars... AND there will be no deletes means no delete and mazbe some small edits but not in the row that is indexed.

U figured it out... GIT has a option to specify the repo location. exec git --git-dir=/git/repolocation/.git reset --hard you have to navigate to the hidden .git file or it wont work... internal git bug.

Hy i have a GIT repo on a specific location and i need to exec it. so i tooth it was like exec git reset --hard but it executes the command as it was on the base root location. I need before i execute the command to go to my GIT repo location. Can someone help me out? I read about it here http://www.linuxjournal.com/content/bash-redirections-using-exec and if i get it i need a named pipe... but i don't get how i can do it ~.~ i am a exec newbie.

But plain text stored in a encryption has no collisions... while md5 has.

You miss the point by few miles.... i am talking about the security for md5 versus just storing plain text.....

Hy i read the topic about the md5 insecurity and the collision possibility.... And now i have a following question. Is it not MUCH more secure to store the actual password in the DB then the md5 value of it?? Because you with it eliminate the collision possibility of the md5 completely. And I am aware of the possibility that someone could break into my DB but if I am dumb enough to let someone access my db, but that is not an issue. I can always use a 2way encryption to store the data.

As far i know there is the command apc_clear_cache() is good but if it dous not clear on the fastCGI then only option is to restart apatche server.

Any idea why the wont relese anymore the handy chm files? It was soooo handy.... :'(

Ye but adobe is always soooo sloooooowwwwww...... chm opens almost instantly while adobe takes about 15 sec....

Sadly not anymore :'( :'( :'( :'( :'( :'( only html and pdf... which is mostly unusable as a quick reference due lacking of the index.... also there is some wiered format which is mostly unusable for me...

Hy i searched and searched but it seems they dont make the .chm help files anymore for mysql... i tried on their site where they used to make it available for download :'( but no luck. I formated my system and forgot to back up the reference help file... and i love it as a quick reference for quick peek in.... Can somone link me or upload the latest (or last) chm file you have???? Thy VERY much in advance

Do you have any advice or...? The query is stated on the end of the 1st post... It can not be simpler... The table is almost full range of int(10) +/- 20% so yes that is many how ever you turn it... And I am asking if anyone knows how to organize the index and the partitioning. The partitioning is as you told not so necessary because i have only 3 columns with a integer in it.... But then again i am inserting a 130 mb CSV in it... and to have at least around 150mb table always read in when a query takes place is not the definition of efficiency i have in mind...

It is giant, dont know the exact number but a query takeas about 1 s... and i have very fast hdd