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
Need help with simple code, back and forward buttons.
Basically, I have a set of pages in a folder, which have the title somephrasehere_09.php, somephrase
phpMailer not working ..........
HI,
I was playing with the phpMailer script and tried to send a smiple mail using their test scri
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
(sub)screen resize modification doesn't work after ECC 6 EhP 4 installation
Hello,
We have previously extended the size of the custom data tab on PO transaction ME23
Adding post count
How would I make it so everytime someone clicks submit on my form, their row in the database for the
IP question
ive got 2 ip addresses both global from same user how would i detect if they are local to each other
Small problem with image resize script
Hi!
I am a little bit new to php and I have an issue installing an image resize script I down
How to restrict the display of report variants
Hello All,
I want t know how to restrict the display of report variants.
I mean, whe
Access database inside of a validation class
Hello,
For quite some time, I have been using functions to validate form input and access the
Not Loading Function Into Div
I'm not sure whether to put this under the php forum or ajax forum but because I tink it's more of a
