My Computer Forum Computer Science Forum

Go Back   My Computer Forum > Web Development Forum > Web Databases

Web Databases Web Databases and SQL


Reply
 
LinkBack Thread Tools Display Modes
April 10th, 2011, 04:24 AM   #1
Site Founder
 
julien's Avatar
 
Joined: Dec 2007
Posts: 414
Indexing tables in a mysql database: autoincrement or not ?

When building tables in a database, is it generally a good idea to index them using the autoincrement option or should we rather manually index the records ?
One drawback of autoincrement is that there's no way to insert records "in between" two consecutive records that were already indexed. On the other hand, if no autoincrement is used and records are indexed with "gaps" between them (eg. first record is 10, second record is 20, etc ... allowing for unused numbers for possible later use), then I guess this must impact performance ?
julien is offline  
 

My Computer Forum is free to register and we welcome everyone!

Reply

  My Computer Forum > Web Development Forum > Web Databases

Tags
autoincrement, database, indexing, mysql, tables



Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Database Types johnny Databases 11 January 2nd, 2014 07:33 AM
Are MySQL tables relationships important ? julien Web Databases 0 May 1st, 2012 03:07 AM
Alternatives to MySQL databases julien Web Databases 4 November 9th, 2010 01:54 PM
Database sizing basic billymac00 Databases 0 December 3rd, 2009 07:20 PM
HELP ME ABOUT DATABASE Programmer Databases 3 February 3rd, 2009 06:28 AM





Copyright © 2018 My Computer Forum Forum. All rights reserved.