Welcome to Geeklog, Anonymous Tuesday, April 01 2025 @ 11:01 pm EDT

Geeklog Forums

Improvements to the Search Page

Post New Reply

Author:

Mood:

Code

Font Color Font Size Close Tags

Forum BBCode Help

BBCode	Effect
[b]bolded text[/b]	bolded text
[i]italicized text[/i]	italicized text
[u]underlined text[/u]	underlined text
[s]strikethrough text[/s]	strikethrough text
[img]http://www.site.com/forum/images/forum.png[/img] OR [img h=65 w=50]http://www.site.com/forum/images/forum.png[/img]
[url=https://www.geeklog.net]Geeklog[/url]	Geeklog
[quote]quoted text[/quote]	To quote: quoted text
[size=15]Your Text[/size] "12" is usually standard on message boards. Usually measured in pixels (px).	Your Text
[color=red]Red Text[/color] OR [color=#FF0000]Red Text[/color] Can use many different color names or hex codes.	Red Text
[list] []List item 1 []List item 2 [/list] OR [list=1] []List item 1 []List item 2 [/list]	List item 1 List item 2 List item 1 List item 2
[code]monospaced text[/code]	monospaced text
[code=XYX]formatted code[/code] Where XYZ can be any of the following: c css html4strict java javascript jquery perl php plain python SQL and many more...	formatted code
To enter a backslash (\) in your post, use \\\\	\

Subject

[QUOTE][u]Quote by: jmucchiello[/u][p][QUOTE][u]Quote by: furiousdog[/u][p][quote]
Geeklog links against the mysql interface, not the mysqli interface and cannot perform prepared statements. Very few shared hosts provide PHP with the mysqli library. Also, many shared hosts still only provide access to mysql 4.1.
[/quote]
I didn't say I had plans on implementing it, I said if it was to be implemented it would be relatively simple, pass a '?' as the search term to a plugin, when the plugin returns the query perform the substitutions. Just because mysqli is not supported by all hosts does not mean everyone has to suffer. It could be set as a configurable option.[/quote]Geeklog does not support the mysqli interface.
[quote]I have already done some work on SQL optimization in previous projects so this is a strong area. Just off the top of my head you can make the query times a lot faster by removing the wild card at the beginning of every LIKE statement, look at the queries all the plugins use, they all have a wild card at the start.[/QUOTE]Those tips you reference are for how to speed up normal queries. Site Search queries are never normal. How do you find all stories with the word 'boxcar' in them when the story text is stored in introtext and bodytext (both are text datatypes) and the word boxcar could be anywhere in the field?
[code]
WHERE introtext like '%boxcar%' OR bodytext like '%boxcar%'
[/code]
Tip #20 only applies to ORs of fields that are indexed individually. Most text fields are not indexed and won't be improved by UNION.

And I throw tips #5 and #15 back at you.[/p][/QUOTE]

Options:

HTML Mode

Geeklog Forums

Search

Resources

About

Getting started

Support

Development

Topics

User Functions

What's New

Articles last 4 weeks

Comments last 4 weeks

Pages last 4 weeks

Links last 4 weeks

Downloads last 4 weeks