Select question
Posted on
16th Feb 2014 07:03 pm by
admin
Hi,
First I would like to say that php is pretty new for me..
so please don't shoot me if this should be a stupid question!
Did you know?Explore Trending and Topic pages for more stories like this.
But I'm a little surpized due to following..
I have a search script (very large mysql db) which is working pretty fast for searching!
I'm using following querry:
Code: $q="SELECT `url`,`caption`, `type`,`fsize`, MATCH (caption) AGAINST ('$kwd2') as score,`source`, `lastcheck`, `dateadded`, `desc`, `media`, `filename`, `sname`, `rating`, `stream`, `id` FROM `v2links` WHERE MATCH (caption) AGAINST ('$kwd2')$stype $fxtype $fxmedia $fsort LIMIT $start,$search_count";sample: http://www.filemirrors.info
Now I would like to display the 30 latest records using following querry:
Code: $q="SELECT `url`,`caption`, `type`, `id`,`fsize`,`source`, `lastcheck`, `dateadded`, `desc`, `media`, `filename`, `sname`, `rating`, `stream`, `id` FROM `v2links` Where checked=1 $stype $fxtype $fxmedia $fsort LIMIT 30";sample: http://www.filemirrors.info/latest.html
Now it seems to take much more time (3x) to display the last 30 records then when using the searchbox and enter a keyword...
I thought a simple select should be going faster then match against a keyword?
Is there an explenation for this or am I missing something?
Thanks
No comments posted yet
Your Answer:
Login to answer
275
38
Other forums
Bluetooth RSSI & VIsta
Okie I got 4 Bluetooth adapters, a DBT-120 by Dlink, A Zonet Microsoft Bluetooth which is what I use
Get word number x from string?
How can I use a function to loop through a string, and "have a look at" every word in the
problem in pagination when processing with selectbox form
Hi,
I have a search form, with select boxes, if am selecting the value from the form, it work
Remote Database Access
Hey guys!!
OK, i'm used to only working with databases from the CPANEL, accessing phpMyAdmin
Removing Title From database problem
Hi again ! i am having an issue with updating database. When i update any price of a title it remove
mySQL and PHP search
Hello,
I am trying to code a project and ran into a brick wall with one of my pages. I am pretty
what are '%S%', '%E%'
for example when i see Code: [Select]printf("Hello %srn", $name);
what does %s means
$variable = $variable
Hello
Sorry if this is a really simple question but I have run out of ideas. Is there a reall
no idea what to do...
I'm fed up. I had issues with code that I have working on a different site that didn't work on my cu
How to add an image/C++ OpenGL?
Hi,
I have been trying to look online for this and, so far, I haven't found anything usef