aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/includes/db
Commit message (Collapse)AuthorAgeFilesLines
* Alright, this should give some improved performance :)David M2008-02-0311-331/+18
| | | | | | | | | | | | | | | | | | This is the end of random seek access to rows. If you have a compelling reason as to why they should stay, contact me. Else, they are gone forevermore... The following API calls are deprecated: acm::sql_rowseek() -> no replacement $db->sql_fetchfield($field, $rownum = false, $query_id = false) -> $db->sql_fetchfield($field, $query_id = false) Initial tests show that phpBB3 over four percent of memory against phpBB3.1 on an empty board. So far so good :) Other cool things: db2, MS SQL ODBC and MS SQL 2005 all use less memory because they do not need to reference the last executed query to handle random access seeks :) P.S. The crazy people using SVN: please report any issues with the new way we itterate through caches, I do not want to miss anything :) git-svn-id: file:///svn/phpbb/trunk@8372 89ea8834-ac86-4346-8a33-228a782c2dd0
* Merging revisions #r8346, #r8347 and #r8348Meik Sievertsen2008-01-291-0/+7
| | | | git-svn-id: file:///svn/phpbb/trunk@8349 89ea8834-ac86-4346-8a33-228a782c2dd0
* #19285David M2008-01-131-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@8324 89ea8834-ac86-4346-8a33-228a782c2dd0
* I suppose I should fix this :PDavid M2008-01-131-2/+2
| | | | git-svn-id: file:///svn/phpbb/trunk@8322 89ea8834-ac86-4346-8a33-228a782c2dd0
* arg, the voices in my head won't let me focus :PDavid M2008-01-111-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@8321 89ea8834-ac86-4346-8a33-228a782c2dd0
* db tools can now drop tablesDavid M2008-01-111-0/+64
| | | | git-svn-id: file:///svn/phpbb/trunk@8320 89ea8834-ac86-4346-8a33-228a782c2dd0
* - use proper OOP for db_toolsDavid M2008-01-111-212/+213
| | | | | | | - made it all static. If one of you disagree, you are free to change it. I just couldn't think of a reason of having it otherwise... git-svn-id: file:///svn/phpbb/trunk@8319 89ea8834-ac86-4346-8a33-228a782c2dd0
* we enter a brave new world...David M2008-01-101-33/+198
| | | | | | | | | - fix schema data so that it can now be used - replace the current system of packaging schemas with phpBB with a new system that dynamically generates the schemas on the fly - give the db tools package the power to create databases git-svn-id: file:///svn/phpbb/trunk@8318 89ea8834-ac86-4346-8a33-228a782c2dd0
* - phpBB now uses a less ancient version of OracleDavid M2008-01-092-11/+11
| | | | git-svn-id: file:///svn/phpbb/trunk@8317 89ea8834-ac86-4346-8a33-228a782c2dd0
* - make viewforum work againDavid M2008-01-081-2/+2
| | | | | | | | | - remove the lower case functions, they were stupid anyway - added some indexes - added a group_name_clean column git-svn-id: file:///svn/phpbb/trunk@8315 89ea8834-ac86-4346-8a33-228a782c2dd0
* - a few tiny clean upsDavid M2008-01-0711-15/+434
| | | | | | | - a new MS SQL DBAL, it does not work so hot because of issues with the extension it depends on git-svn-id: file:///svn/phpbb/trunk@8313 89ea8834-ac86-4346-8a33-228a782c2dd0
* - add DB2 supportDavid M2008-01-062-4/+587
| | | | | | | /me takes a nap git-svn-id: file:///svn/phpbb/trunk@8308 89ea8834-ac86-4346-8a33-228a782c2dd0
* the end of an era...David M2008-01-063-111/+41
| | | | | | | | | - MySQL < 4.1.3 support is removed - renamed mysql4 to mysql, no need to cause confusion - changed the cfg cacher, reduces file system lookups and include count by two on every page load git-svn-id: file:///svn/phpbb/trunk@8307 89ea8834-ac86-4346-8a33-228a782c2dd0
* Ch-ch-ch-changesDavid M2008-01-049-3/+150
| | | | | | | | | | | - Made us more DB independent by making many queries capability based instead of DB specific - Finished PHP5ifying of the acm_file class, now with some (hopefully) enhancements to its performance - Sped up viewforum considerably (also goes towards mcp_forum) I really hope I didn't explode CVS... git-svn-id: file:///svn/phpbb/trunk@8301 89ea8834-ac86-4346-8a33-228a782c2dd0
* oh boy...David M2008-01-037-110/+80
| | | | | | | - Migrate code base to PHP 5.1+ git-svn-id: file:///svn/phpbb/trunk@8295 89ea8834-ac86-4346-8a33-228a782c2dd0
* commit all transactions on closing the db (there is only one, but we support ↵Meik Sievertsen2007-12-061-1/+5
| | | | | | inner transactions - logically speaking) git-svn-id: file:///svn/phpbb/trunk@8271 89ea8834-ac86-4346-8a33-228a782c2dd0
* - on database update, execute garbage_collection(). This ensures a proper ↵Meik Sievertsen2007-12-061-1/+6
| | | | | | | | | | | closed db and written cache - on sql errors returning (and not triggering an error) execute the rollback too both "bugs" resulted in transactions left open if a query returned an error on database update preventing a clean update. Symptoms being for example oracle users not having all database info updated, the version number not changing or config variables not written. git-svn-id: file:///svn/phpbb/trunk@8270 89ea8834-ac86-4346-8a33-228a782c2dd0
* further updatesMeik Sievertsen2007-11-191-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@8248 89ea8834-ac86-4346-8a33-228a782c2dd0
* hopefully fixing bug #14890 - need to test laterMeik Sievertsen2007-11-191-6/+10
| | | | git-svn-id: file:///svn/phpbb/trunk@8247 89ea8834-ac86-4346-8a33-228a782c2dd0
* MSSQL works properly with SQL update related toolsDavid M2007-10-161-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@8198 89ea8834-ac86-4346-8a33-228a782c2dd0
* small fixMeik Sievertsen2007-10-121-1/+1
| | | | | | | - david: please review the mssql change git-svn-id: file:///svn/phpbb/trunk@8165 89ea8834-ac86-4346-8a33-228a782c2dd0
* dumdidum... sorry. ;)Meik Sievertsen2007-10-0510-60/+69
| | | | git-svn-id: file:///svn/phpbb/trunk@8147 89ea8834-ac86-4346-8a33-228a782c2dd0
* misc SQLite bugsDavid M2007-09-221-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@8101 89ea8834-ac86-4346-8a33-228a782c2dd0
* - some language tweaks suggested by JohnMeik Sievertsen2007-09-131-0/+1405
| | | | | | | | - some bug fixes - finally adding db_tools... git-svn-id: file:///svn/phpbb/trunk@8088 89ea8834-ac86-4346-8a33-228a782c2dd0
* some tiny fixes...Meik Sievertsen2007-09-121-2/+2
| | | | git-svn-id: file:///svn/phpbb/trunk@8087 89ea8834-ac86-4346-8a33-228a782c2dd0
* necessary changes...Meik Sievertsen2007-08-301-2/+4
| | | | git-svn-id: file:///svn/phpbb/trunk@8072 89ea8834-ac86-4346-8a33-228a782c2dd0
* #14207David M2007-08-241-2/+6
| | | | git-svn-id: file:///svn/phpbb/trunk@8069 89ea8834-ac86-4346-8a33-228a782c2dd0
* #14211David M2007-08-241-1/+1
| | | | | | | - doing is_null on Oracle is not good, we return empty strings instead git-svn-id: file:///svn/phpbb/trunk@8068 89ea8834-ac86-4346-8a33-228a782c2dd0
* patch by david for #14182Meik Sievertsen2007-08-241-7/+3
| | | | git-svn-id: file:///svn/phpbb/trunk@8066 89ea8834-ac86-4346-8a33-228a782c2dd0
* increase the odbc limit (64k is too low, the theme data itself is >64k)Meik Sievertsen2007-08-161-1/+22
| | | | git-svn-id: file:///svn/phpbb/trunk@8038 89ea8834-ac86-4346-8a33-228a782c2dd0
* turn on strict mode for databases that support itDavid M2007-08-142-1/+51
| | | | git-svn-id: file:///svn/phpbb/trunk@8029 89ea8834-ac86-4346-8a33-228a782c2dd0
* #13916David M2007-08-021-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@7995 89ea8834-ac86-4346-8a33-228a782c2dd0
* #13874David M2007-07-301-1/+8
| | | | git-svn-id: file:///svn/phpbb/trunk@7981 89ea8834-ac86-4346-8a33-228a782c2dd0
* this should work fine now...Meik Sievertsen2007-07-241-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@7937 89ea8834-ac86-4346-8a33-228a782c2dd0
* #13151David M2007-07-091-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@7849 89ea8834-ac86-4346-8a33-228a782c2dd0
* #13033David M2007-07-052-12/+12
| | | | git-svn-id: file:///svn/phpbb/trunk@7835 89ea8834-ac86-4346-8a33-228a782c2dd0
* Firebird tooDavid M2007-06-241-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@7791 89ea8834-ac86-4346-8a33-228a782c2dd0
* tweak the sql_like_expression feature a little bit to allow correct escapingMeik Sievertsen2007-06-249-34/+77
| | | | git-svn-id: file:///svn/phpbb/trunk@7789 89ea8834-ac86-4346-8a33-228a782c2dd0
* new wrapper for LIKE expressions to streamline the fixes. We actually need ↵Meik Sievertsen2007-06-234-0/+61
| | | | | | to adjust them for different DBMS as well as SQLite2 not supporting escaping characters in LIKE statements (which is a reason why we think about dropping sqlite support completely). git-svn-id: file:///svn/phpbb/trunk@7788 89ea8834-ac86-4346-8a33-228a782c2dd0
* #12415David M2007-06-182-2/+3
| | | | git-svn-id: file:///svn/phpbb/trunk@7778 89ea8834-ac86-4346-8a33-228a782c2dd0
* - tiny changesDavid M2007-06-183-56/+12
| | | | git-svn-id: file:///svn/phpbb/trunk@7773 89ea8834-ac86-4346-8a33-228a782c2dd0
* - Oracle can't handle IN clauses with more than 1000 elements (Bug #12449)David M2007-06-162-34/+65
| | | | | | | - Firebird can now work properly in PHP4 git-svn-id: file:///svn/phpbb/trunk@7767 89ea8834-ac86-4346-8a33-228a782c2dd0
* correctly re-assign query resultMeik Sievertsen2007-06-128-8/+8
| | | | git-svn-id: file:///svn/phpbb/trunk@7753 89ea8834-ac86-4346-8a33-228a782c2dd0
* - Oracle gives us null instead of '', this is now fixed (thanks APTX)David M2007-06-091-1/+68
| | | | | | | - Oracle can now explain queries git-svn-id: file:///svn/phpbb/trunk@7741 89ea8834-ac86-4346-8a33-228a782c2dd0
* ok, mess around with the templates + fixing some bugs + adjusting headers ↵Meik Sievertsen2007-06-091-3/+3
| | | | | | for those files already modified to circumvent conflicts for those having their editor set to remove trailing spaces (not recommended!) git-svn-id: file:///svn/phpbb/trunk@7736 89ea8834-ac86-4346-8a33-228a782c2dd0
* - Oracle, woe is you... I will say this much, this fixes Oracle's handling ↵David M2007-06-071-4/+110
| | | | | | of empty strings... We also fix custom profiles and now provide database size for Oracle... git-svn-id: file:///svn/phpbb/trunk@7721 89ea8834-ac86-4346-8a33-228a782c2dd0
* d'oh!David M2007-05-251-2/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@7676 89ea8834-ac86-4346-8a33-228a782c2dd0
* - added support for Oracle's easy connect namingDavid M2007-05-231-2/+15
| | | | git-svn-id: file:///svn/phpbb/trunk@7671 89ea8834-ac86-4346-8a33-228a782c2dd0
* #11255David M2007-05-221-1/+2
| | | | | | | | | | | | | | | #11259 #11291 #11335 #11457 #11473 #11475 #11511 #11523 #11527 git-svn-id: file:///svn/phpbb/trunk@7663 89ea8834-ac86-4346-8a33-228a782c2dd0
* oh my god - what did he do? Adding attachment display to post/topic review, ↵Meik Sievertsen2007-05-191-3/+3
| | | | | | queue, reports, post details, mcp topic view... fixing other tiny things along the line. git-svn-id: file:///svn/phpbb/trunk@7642 89ea8834-ac86-4346-8a33-228a782c2dd0
generated by cgit v1.2.1 (git 2.21.0) at 2025-10-10 22:19:29 +0000