diff options
| author | Dries Buytaert <dries@buytaert.net> | 2003-08-12 18:32:54 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2003-08-12 18:32:54 +0000 |
| commit | 7af49ab274e7ea650abfecb323ae4b510960b5c3 (patch) | |
| tree | 7e9e586af70bd817262aac501c73c6b545f5911b /database | |
| parent | ab6db2867158923f17601edfd9718151dbfb304a (diff) | |
| download | brdo-7af49ab274e7ea650abfecb323ae4b510960b5c3.tar.gz brdo-7af49ab274e7ea650abfecb323ae4b510960b5c3.tar.bz2 | |
- Committed Marco's comment module patch:
+ Dramatically improves performance of large discussions/threads: only
very few SQL queries are required.
+ Replaces custom pager with standard pager.
Modifications by me:
+ Reworded some code comments.
+ Removed dependencies on pager internals.
Diffstat (limited to 'database')
| -rw-r--r-- | database/database.mssql | 1 | ||||
| -rw-r--r-- | database/database.pgsql | 1 |
2 files changed, 2 insertions, 0 deletions
diff --git a/database/database.mssql b/database/database.mssql index a5f1a698e..25eb3a1f9 100644 --- a/database/database.mssql +++ b/database/database.mssql @@ -83,6 +83,7 @@ CREATE TABLE [dbo].[comments] ( [link] [varchar] (16) NULL , [score] [int] NOT NULL , [status] [tinyint] NOT NULL , + [thread] [varchar] (255) NOT NULL , [users] [varchar] (8000) NULL ) ON [PRIMARY] GO diff --git a/database/database.pgsql b/database/database.pgsql index 2e26a9f4f..9c8232514 100644 --- a/database/database.pgsql +++ b/database/database.pgsql @@ -123,6 +123,7 @@ CREATE TABLE comments ( link varchar(16) NOT NULL default '', score integer NOT NULL default '0', status smallint NOT NULL default '0', + thread vharchar(255) NOT NULL, users text default '', PRIMARY KEY (cid) ); |