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

Hy guys I have a bit of an issue with instaling and optimising a GIANT table.... most of you know the GeoIp database... well im trzing to optimise so it can run on mysql the job giver is to stingy to pay the binary version.... so i ahve tor esort to the CVS version of it... i imported it and it is slowwwwwww How can i speed it up? CREATE TABLE IF NOT EXISTS `GeoIpBlocks` ( `startIpNum` INT(10) UNSIGNED NOT NULL , `endIpNum` INT(10) UNSIGNED NOT NULL , `locId` INT(10) UNSIGNED NOT NULL , PRIMARY KEY (`startIpNum`, `endIpNum`) ) ENGINE = MyISAM It has 300k+ rows.... I know i need ti make it partitioned but on what basis? I think range is best.... here is an example of the content of the table 16777216 17301503 17 17367040 17432575 153 17435136 17435391 17 17498112 17563647 119 17563648 17825791 49 17825792 18087935 119 18153472 18219007 111 18219008 18350079 103 18350080 18874367 49 18939904 19005439 111 19005440 19136511 218 19136512 19202047 94 19267584 19398655 103 19398656 19726335 17 19726336 19791871 49 19791872 19922943 209 19922944 20054015 49 20054016 20058111 2 The only query which will run on this table is SELECT locId FROM GeoIpBlocks WHERE some_int_value BETWEEN startIpNum AND endIpNum; Anz advise wuold be apriciated.

You sure about that???

Hy i am making part of a site will be refereed to get some java script via <script type="text/javascript" src="the link"> Now i am wondering the server sends back some kind of header so can i just use the setcookie function to send him the cookie or do i have to do it some other way because it is only a JavaScript that gets returned??? I think i can just cal the set cookie function, but im not sure

sorry to ask... but why do you need to know the exact values??? because i am only asking if i should or should now use a hash index for it and what key size i should use for the hash index..... as for exact values the one is a cookie value and other one is to int converted IP value so the table will have an index which is targeting the values in the ip and cookie value row so what key block size should i set...what is there more you need to know...

I will have :-\ and i will make queries like select * from where col1 = some value or something like that

Hy i have a table which will have GIANT traffic on it like 400q+ in sec i can ease it up with query cashing but it will still have BIG load on it. The table is made out of 2 int fields and one timestamp. One stores ip addresses one rand generated numbers. So i am asking what is the best way to index the table... the access is totally random so i need single seek access mode. I was thinking of an hash index on it what do you think? The table will be always half full and there will be double entry's in both colons because the primary key are both columns what key block size should i set?

Hy i`m making a site which needs to identify unique users so far nothing new. Now because i want to identify the visitors as unique ones i am thinking to give each of them a cookie with a random generated value in it and i plan to note their ip address to. now i am thinking of making a table in which i store following values IP, cookie value, visiting time My question is are there any better options to identify the unique visitors than this... which would mean less load on my DB >?< Because this solution would load my BD pretty hard Q.Q And i dont want to take any chance with it, mean i want 99,99% secure way to identify unique users.... any suggestions on this????

Anyone?

Hy i am curios is there a way to compile it on Windows????? I am trying but i miss the php and zend .h files .... somone knows how to compile it????

this part of their license is the rock in my road I cant have that in the project nor can i put it in it... becouse the "quest"(wow addict) giver dous not want it on his site.....