Ad Widget

Collapse

dbpatches

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • den_crane
    Senior Member
    • Feb 2006
    • 272

    #1

    dbpatches

    I'm not experienced mysql dba, but in oracle, informix rdbms faster create indexes after filling table.

    I see in patch.sql statements CREATE TABLE, CREATE INDEX, insert into
    May be faster CREATE TABLE, insert into, CREATE INDEX ?
    Last edited by den_crane; 30-05-2007, 15:12.
  • Alexei
    Founder, CEO
    Zabbix Certified Trainer
    Zabbix Certified SpecialistZabbix Certified Professional
    • Sep 2004
    • 5654

    #2
    Indeed, an index can be created afterwards in order to save time and perhaps make the index slightly faster. However I decided to keep the patches as simple as we can in order to keep them readable. It is up-to a database administrator to optimize it.
    Alexei Vladishev
    Creator of Zabbix, Product manager
    New York | Tokyo | Riga
    My Twitter

    Comment

    Working...