Jump to content


Click here to lend your support to: Traq and make a donation at pledgie.com !
Photo

db indexes


  • Please log in to reply
4 replies to this topic

#1 timoline

timoline

    Newbie

  • Members
  • Pip
  • 9 posts

Posted 03 August 2014 - 08:41 AM

As far as I can remeber from a previous (joomla)project, we created indexes in the database to improve performance...

 

for example the ticket_history table

 

1 id

2 user_id -> create an index

3 ticket_id -> create an index

4 changes

5 comments

6 created at

 

http://www.tutorials...sql-indexes.htm

 

But maybe its something for traq 4.x



#2 paulhobbel

paulhobbel

    Member

  • Members
  • PipPip
  • 28 posts

Posted 04 August 2014 - 11:21 PM

Yea that would be nice and it will improve the performance 


Bootstrap Theme for Traq here | Dutch Translation for Traq here | Theme demo here


#3 Jack

Jack

    Project Founder

  • Administrators
  • 673 posts
  • LocationAustralia

Posted 05 August 2014 - 01:42 AM

I plan to do this in Traq 4.0 with the new way database changes are handled.

 

4.0 is using a new framework called Radium, which includes database migrations, which can be seen with the updated plugins table. There's still a lot to do and some changes to make.

 

When the migration from 3.6 to 4.0 is done, the database structure will be completely updated and indexes will be created.



#4 paulhobbel

paulhobbel

    Member

  • Members
  • PipPip
  • 28 posts

Posted 06 August 2014 - 10:23 AM

I'm looking forward to it :D


Bootstrap Theme for Traq here | Dutch Translation for Traq here | Theme demo here


#5 timoline

timoline

    Newbie

  • Members
  • Pip
  • 9 posts

Posted 08 August 2014 - 01:26 PM

I'm looking forward to it :D

Me too  :)




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users