PostgreSQL database sql
Just look at new features:
Greatly improved performance consistency, through HOT, Load Distributed Checkpoint, JIT bgwriter, Asynchronous Commit, and other features.
TSearch2 full text search integrated into the core code with improved syntax and ease of adding custom dictionaries.
SQL:XML syntax.
Logging to database-loadable CSV files.
Automated rebuilding of cached plans.
ENUMs, UUIDs [...]
basics, content, database, full, full-text, howto, implementation, index, indexing, MySQL, search, sql, Sqlite, text
Basic approach
tokenize into words
case folding
stemming (convert each word into its root form; porter stemmer very popular stemmer for English
remove stop words
for each word left create posting list per word
Queries
OR queries do an intersection
AND queries do a union
Phrase Queries
Bad way: Do an [...]
New hot Adobe Flash Player 9 got support for H.264 video and High Efficiency AAC audio codecs in the latest update, available in beta on Adobe Labs.
Adobe Labs features prerelease versions of the Flash Player 9 Update software. The beta is an opportunity for developers and consumers to test and provide early feedback to Adobe on [...]
adobe creative+suite uninstall installer+bug msi msiexec manual+uninstall
If you have installed Adobe Creative Suite 2.0 it can be impossible to uninstall Suite applications due to installer bug. Setup.exe is crashing every time I’m trying to manage my Adobe Creative Suite installation. It’s big annoyance, because Windows won’t allow to uninstall individual suite applications, telling that [...]
php opcode+cache apc xcache eaccelerator mmcache issues require_once
If you got a large OO PHP application, you usually come with many files included using “require_once()”. Different test from different sources shows that using require_once works up to 4 times slower than require. Basically, all known PHP opcode caches suffers from this issue (APC, XCache, ea/mmcache).
There’s patches [...]
php cache apc autoload
The Alternative PHP Cache (APC) is a free and open opcode cache for PHP. It was conceived of to provide a free, open, and robust framework for caching and optimizing PHP intermediate code.
Many developers writing object-oriented applications create one PHP source file per-class definition. Using __autoload() helps to overcome one of [...]
web server database hosting Your dedicated server suffer from overload? It’s time to get bigger! The good step forward is 2 web + 1 database server. If you do not want to split media content and dynamic pages between different servers, you probably need loadbalancer.