Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> Bug Fixes
Author Message
shmk
Worker
Worker


Joined: Dec 21, 2004
Posts: 116

PostPosted: Mon Sep 05, 2005 10:14 am Reply with quote

In most of db tables I got this Warning (translation form italian so it could be not perfect):

Code:
The keys PRIMARY and INDEX couldn't be assigned to se same column "A_COLUMN_NAME"


Is this a problem ? How can I solve it ?
 
View user's profile Send private message
Raven
Site Admin/Owner


Joined: Aug 27, 2002
Posts: 17077

PostPosted: Mon Sep 05, 2005 11:53 am Reply with quote

It doesn't cause a problem other than overhead. You should be able to drop the INDEX and just leave the PRIMARY.
 
View user's profile Send private message
shmk
PostPosted: Mon Sep 05, 2005 3:10 pm Reply with quote

Raven wrote:
You should be able to drop the INDEX and just leave the PRIMARY.


This makes better (less time loading a page) and worst (most time searching in db) speed ?
 
Raven
PostPosted: Mon Sep 05, 2005 5:34 pm Reply with quote

It shouldn't. Whether the index is a regular or primary, the query should still use it.
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> Bug Fixes

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©