aboutsummaryrefslogtreecommitdiff
path: root/engine/lib/database.php
AgeCommit message (Collapse)Author
2008-11-06* Database functions optimised and centralised a bitmarcus
* Caching now caches queries which return no data * Introducing execute_delayed_query family for executing queries AFTER the page has loaded. git-svn-id: https://code.elgg.org/elgg/trunk@2414 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-11-05Revert use of memcache for database query cachemarcus
git-svn-id: https://code.elgg.org/elgg/trunk@2403 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-11-04More tweaksmarcus
git-svn-id: https://code.elgg.org/elgg/trunk@2400 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-11-04Moved caching to function so it can be easily replacedmarcus
git-svn-id: https://code.elgg.org/elgg/trunk@2390 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-11-03Database using new memory cache objectmarcus
git-svn-id: https://code.elgg.org/elgg/trunk@2385 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-11-03Experimental database query caching, please report problems asap.marcus
git-svn-id: https://code.elgg.org/elgg/trunk@2383 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-11-03Experimental database query caching, please report problems asap.marcus
git-svn-id: https://code.elgg.org/elgg/trunk@2381 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-10-31Closes #493: Moved database queries out of module and in to core in line ↵marcus
with best practice. git-svn-id: https://code.elgg.org/elgg/trunk@2369 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-10-07Closes #409: PHP update script to update core addedmarcus
git-svn-id: https://code.elgg.org/elgg/trunk@2208 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-10-01Fixes #395marcus
git-svn-id: https://code.elgg.org/elgg/trunk@2157 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-09-23The database schema will now automatically update itself on upgrade.ben
git-svn-id: https://code.elgg.org/elgg/trunk@2107 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-09-20Apparently non-p connections are better in many cases, see ↵marcus
http://www.slideshare.net/techdude/how-to-kill-mysql-performance git-svn-id: https://code.elgg.org/elgg/trunk@2101 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-09-06Fixes #330: I implemented the changes you suggested (except for quotes ↵marcus
around the table name). What problems did you encounter? git-svn-id: https://code.elgg.org/elgg/trunk@2055 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-08-19Refs #266: Error given if no database has been set up.marcus
git-svn-id: https://code.elgg.org/elgg/trunk@2017 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-08-19Refs #256: Basic installation parameters checked.marcus
Fixes #266: If the install flag isn't set then elgg_view will no longer attempt to load data from the database. git-svn-id: https://code.elgg.org/elgg/trunk@2016 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-07-08Removing annoying warning messagesben
git-svn-id: https://code.elgg.org/elgg/trunk@1328 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-06-27git-svn-id: https://code.elgg.org/elgg/trunk@1194 ↵marcus
36083f99-b078-4883-b0ff-0f9b5a30f544
2008-06-27Using persistent db connections. This should speed up pages with numerous ↵marcus
small DB calls. Please report any issues asap. Refs #101 git-svn-id: https://code.elgg.org/elgg/trunk@1184 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-06-27Removed explains since these weren't much usemarcus
git-svn-id: https://code.elgg.org/elgg/trunk@1180 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-06-27Refs #101 - DB Profiling in debug mode (recommended usage means putting ↵marcus
$CONFIG->debug = true in settings.php) git-svn-id: https://code.elgg.org/elgg/trunk@1173 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-06-24Caching the show_db_tables functionben
git-svn-id: https://code.elgg.org/elgg/trunk@1114 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-06-20Removed database gatekeepers to avoid chicken and egg problems with ↵marcus
privileged codeblock execution, and because it is too problematic. git-svn-id: https://code.elgg.org/elgg/trunk@1019 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-06-20update_data now returns true on a successful update.ben
git-svn-id: https://code.elgg.org/elgg/trunk@1016 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-06-19Re-enabled database gatekeepers, please report problems.marcus
Refs #3, #45 git-svn-id: https://code.elgg.org/elgg/trunk@1010 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-06-18Re-commented out callpath_gatekeeper. refs #37ben
git-svn-id: https://code.elgg.org/elgg/trunk@975 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-06-17Fixed #37. It turns out callpath_gatekeeper worked fine; PHP 5.2 with the ↵ben
Zend Optimizer 3.2 does not, which was borking our OSX MAMP installation. We're going to need a great big red warning box for people installing on a Mac, alerting them to the fact that they'll need to switch off the Optimizer. git-svn-id: https://code.elgg.org/elgg/trunk@950 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-06-17Removed references to callpath_gatekeeper.ben
git-svn-id: https://code.elgg.org/elgg/trunk@948 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-06-17Disabling the gatekeeper for now. Reopened #3ben
git-svn-id: https://code.elgg.org/elgg/trunk@947 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-06-13Marcus Povey: CLOSED - # 9: FilePluginFile not found marcus
http://trac.elgg.org/ticket/9 git-svn-id: https://code.elgg.org/elgg/trunk@908 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-06-11Marcus Povey <marcus@dushka.co.uk>icewing
* All queries echoed in debug mode git-svn-id: https://code.elgg.org/elgg/trunk@870 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-06-10Marcus Povey <marcus@dushka.co.uk>icewing
* Spelling error git-svn-id: https://code.elgg.org/elgg/trunk@859 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-06-10register_event_handler and trigger_event have been renamed to ↵ben
register_elgg_event_handler and trigger_elgg_event respectively. git-svn-id: https://code.elgg.org/elgg/trunk@848 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-06-10Marcus Povey <marcus@dushka.co.uk>icewing
* Debug added to db connect git-svn-id: https://code.elgg.org/elgg/trunk@847 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-06-05Marcus Povey <marcus@dushka.co.uk>icewing
* Partial internationalisation of exceptions git-svn-id: https://code.elgg.org/elgg/trunk@801 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-06-04Marcus Povey <marcus@dushka.co.uk>icewing
* Moved Query object et al to their own file git-svn-id: https://code.elgg.org/elgg/trunk@785 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-06-03Marcus Povey <marcus@dushka.co.uk>icewing
* Minor doc tweak git-svn-id: https://code.elgg.org/elgg/trunk@784 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-06-03Marcus Povey <marcus@dushka.co.uk>icewing
* Added documentation git-svn-id: https://code.elgg.org/elgg/trunk@783 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-06-02git-svn-id: https://code.elgg.org/elgg/trunk@775 ↵icewing
36083f99-b078-4883-b0ff-0f9b5a30f544
2008-06-02Marcus Povey <marcus@dushka.co.uk>icewing
* Fixed set ommission git-svn-id: https://code.elgg.org/elgg/trunk@774 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-06-02Marcus Povey <marcus@dushka.co.uk>icewing
* BUGFIX: Missing $CONFIG from insert_data git-svn-id: https://code.elgg.org/elgg/trunk@768 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-05-30Marcus Povey <marcus@dushka.co.uk>icewing
* Bugfix on gatekeeper and forcing data functions to privileged only git-svn-id: https://code.elgg.org/elgg/trunk@765 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-05-29git-svn-id: https://code.elgg.org/elgg/trunk@753 ↵icewing
36083f99-b078-4883-b0ff-0f9b5a30f544
2008-05-28Marcus Povey <marcus@dushka.co.uk>icewing
* Minor doc update git-svn-id: https://code.elgg.org/elgg/trunk@741 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-05-28Marcus Povey <marcus@dushka.co.uk>icewing
* Minor doc update git-svn-id: https://code.elgg.org/elgg/trunk@740 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-05-28Marcus Povey <marcus@dushka.co.uk>icewing
* Fixed Where, WhereStatic and WhereSet git-svn-id: https://code.elgg.org/elgg/trunk@739 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-05-28Marcus Povey <marcus@dushka.co.uk>icewing
* Fixed order/limit git-svn-id: https://code.elgg.org/elgg/trunk@738 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-05-28Marcus Povey <marcus@dushka.co.uk>icewing
* Fixed tables git-svn-id: https://code.elgg.org/elgg/trunk@737 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-05-28Marcus Povey <marcus@dushka.co.uk>icewing
* Fixed spacing issue git-svn-id: https://code.elgg.org/elgg/trunk@736 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-05-28Marcus Povey <marcus@dushka.co.uk>icewing
* Throws exception if fields are missing on a select query git-svn-id: https://code.elgg.org/elgg/trunk@735 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-05-28Marcus Povey <marcus@dushka.co.uk>icewing
* Fixed $CONFIG->prefix now $CONFIG->dbprefix * Exception thrown on missing tables git-svn-id: https://code.elgg.org/elgg/trunk@734 36083f99-b078-4883-b0ff-0f9b5a30f544