| Author |
Post |
|
|
#1 Sun May 21, 2006 4:06 pm
|
|
Member
Registered: May 2006
Posts: 2
|
Reading install/schemas/mysql.sql, I noticed that there are absolutely no indexes (foreign keys) generated on any of the tables in the database, except for the primary keys.
Is this done on purpose, for the sake of insert speed or tablesize? I guess it would not hurt to use some extra indexes here and there.
Sorry if this was mentioned before. I'm new to UseBB but searched the forum.
# UseBB version: 1.0 RC2 (Version Check)
# PHP version: 5.1.2
# SQL server driver: MySQL/5.0.20a
# HTTP server: Apache
# Operating system: Linux
|
|
|
#2 Sun May 21, 2006 6:05 pm
|
|
Developer
Registered: Apr 2004
Posts: 2224
Location: Belgium
|
The database scheme is quite old, I haven't yet thought of adding keys to it. Will check this for RC3. |
|
|
#3 Wed May 24, 2006 8:25 pm
|
|
Developer
Registered: Apr 2004
Posts: 2224
Location: Belgium
|
I've decided not to put in any of them... 1.0's SQL scheme isn't really consistent after all and a new one is about to be designed for 2.0. Unless it would really improve speed I doubt it if it would be of any improvement without big changes in the code. |
