msr Posted June 18, 2007 Share Posted June 18, 2007 this is a great forum...and i hope to contribute to it soon... in this forum, my second question is about dealing with databases... i have a database that keeps adding daily....it has a text field that can contain upto 10 KB and about 1000 words...(all unicodes)...if i start picking up individual words and index them, it will grow to about 1 million words/month (at the least now)... what i fear is that soon the database may grow so large that even indexing may not be efficient... i found mentions in this forum that mysql handles millions of records easily... what about millions and millions of records with multiple search keys? that should be taking a lot of time....[i really wonder how search engines tackle billions of records... i did research them but still have not got much idea...im seeking this for knowledge, not for commercial purpose really!...;-) it is just that it is interesting...] i also want to try different methodologies... but calculating the time taken to execute a set of routines seems difficult... there is no such 'timer' function in php... or, are there?... im still finding it difficult to handle unicodes... some sort of necessary 'evil'... php, like most languages, has not bothered about handling unicodes... all communications, after all, are not only in english... thanks....best wishes Quote Link to comment https://forums.phpfreaks.com/topic/56111-some-little-ideas-about-phpmysql/ Share on other sites More sharing options...
Wildbug Posted June 18, 2007 Share Posted June 18, 2007 Timing execution speeds: http://us2.php.net/manual/en/function.microtime.php Quote Link to comment https://forums.phpfreaks.com/topic/56111-some-little-ideas-about-phpmysql/#findComment-277151 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.