Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Can this be optimized (probably a newbie question)
I tried it with articleTitle (the full title) rather than articleID because, for historical reasons, there's not a universal ID in the database (I could construct one by a concat, but I'm expecting that'd be slow as well). Also, articleTitle is a key, but not the primary key. The incrementing... -
Can this be optimized (probably a newbie question)
> hmmm, i wonder if two articles are allowed to have the exact same title... It is possible, but very unlikely. However, there are certainly many instances of the article title in the table since we're looking at number of reads. Are you implying something here (if so, I'm not gettin' it)... -
Can this be optimized (probably a newbie question)
I've got a big databases (1.4M records) with about 40 fields. It's doing very enhanced log analysis. One of the fields is the title of an article, defined as a VARCHAR(255). The field is indexed. The engine is InnoDB. When I do the following query, the process takes forever: SELECT...
