Thank you Asif. That helped. But if anyone knows of any site or article on this it would help a great deal since we are at a design phase and I need to convince my design team that we should go for integers as primary keys.
Valli IIC SSS INDIA -----Original Message----- From: A mailing list about Java Server Pages specification and reference [mailto:[EMAIL PROTECTED]]On Behalf Of Asif.Raj Sent: Friday, July 26, 2002 2:39 PM To: [EMAIL PROTECTED] Subject: Re: OFFTOPIC: Primary key data type in tables - does it make a di fference? very good question. i haven't checked the details of it anywhere but tested it with 10 million records on my system PIII, 128MB. there is a noticeable difference when the primary key is an integer and when it is a varchar. it gave me a difference of an average of 5 seconds when selected 4000 records in similar conditions and similar queries. anyone else did any significant test, pls mail back hope this helps asif > -----Original Message----- > From: Sowbhagya Valli Suryadevara > [mailto:[EMAIL PROTECTED]] > Sent: Friday, July 26, 2002 1:26 PM > To: [EMAIL PROTECTED] > Subject: OFFTOPIC: Primary key data type in tables - does it make a > difference? > > > Sorry for the off topic, but I have searched the web and was > unable to find > the answer to my question. If anyone can direct me to a > relevant site I > would greatly appreciate it !!! > > Here is my question : > > Does the data type of the primary key make a difference in > the speed of the > query? I am talking about the difference between int and > varchar when the > number of records are in millions. The database could be > mySql, Oracle etc. > > Thank you > Valli > IICSSS > INDIA > > ============================================================== > ============= > To unsubscribe: mailto [EMAIL PROTECTED] with body: > "signoff JSP-INTEREST". > For digest: mailto [EMAIL PROTECTED] with body: "set > JSP-INTEREST DIGEST". > Some relevant FAQs on JSP/Servlets can be found at: > > http://archives.java.sun.com/jsp-interest.html > http://java.sun.com/products/jsp/faq.html > http://www.esperanto.org.nz/jsp/jspfaq.jsp > http://www.jguru.com/faq/index.jsp > http://www.jspinsider.com > =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
