[development] Doubt on Index and Primary key

nan wich nan_wich at bellsouth.net
Fri Mar 18 02:00:16 UTC 2011

Well, you know uid is unique and commonly joined on already. How many John 
Smith's do you think might submit a resume?

You can search on any column (or combination) whether or not it is indexed. 
Indexing will make it quicker.
Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.


From: Austin Einter

In .install file, in hook_schema unction, we are mentioning index field and 
primary key field.

I am wondering, how to choose which one should be index and which one should be 
primary key.
Does that affect the performance (in search, add, delete of records).

What I am thinking at this point of time,  my database will contain job seekers 
name, mail-id, contact number, skill set (as comma separated values) and resume.

For index purpose, I am thinking I will use '$user->uid' as Index and and 'name' 
as primary key.

I am bit confused how it it is going to affect search/add/delete time (assuming 
huge number of records in database) and also database management.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/development/attachments/20110317/3bcda932/attachment-0001.html 

More information about the development mailing list