Solved

how does autocommit session variable affect indexes

Posted on 2011-02-21
1
503 Views
Last Modified: 2012-05-11
Hello

I believe with the variable autocommit set to 0, the db will not commit each record one at a time during an insert, but commit them all at the end of the load which will be faster.

How does this affect the indexes? Does the database update the indexes after it has done all of the inserts or does it still update the index after each insert?

thanks
0
Comment
Question by:andieje
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 27

Accepted Solution

by:
Nopius earned 500 total points
ID: 34951938
> How does this affect the indexes? Does the database update the indexes after it has done all of the inserts or does it still update the index after each insert?


Until data is committed, there is nothing to index (say there is no data in the DB).
So it indexes it on commit.

Regards,
Arty
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Couls you point a way to make Codeigniter to consider the UTF-8 characters in config.php? 14 89
remote mysql 8 53
MySQL 5.6.30 - daily outages 46 86
MySQL recovery 7 58
Foreword This is an old article.  Instead of using the MySQL extension that was used in the original code examples, please choose one of the currently supported database extensions instead.  More information is available here: MySQLi / PDO (http://…
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question