Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Fastest Data Types To Retrieve

Status
Not open for further replies.
ThinPeter

ThinPeter

Programmer
Dec 8, 2004
3
US
I'm dealing with tables with records in the tens of millions. The data is basically static. Is CHAR the fastest data type to retrieve? Would changing TINYINT fields to a CHAR(1) help retrieval performance?

Thanks.

- ThinPeter
 
Sort by date Sort by votes
numerics are the fastest...

Bastien

Cat, the other other white meat
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

EdLentz
  • Locked
  • Question
Looking for suggestions on how to do this
Replies
4
Views
405
Chris Miller
Chris Miller
E
  • Locked
  • Question
MySQL calculator tools
Replies
0
Views
269
EdZzy
E
EdLentz
  • Locked
  • Question
Need to compare two tables and list the differences
Replies
3
Views
441
EdLentz
EdLentz
Marclem
  • Locked
  • Question
Get users Last Login Data 1
Replies
13
Views
1K
Marclem
Marclem
waubain
  • Locked
  • Question
Reset cumulative sum to zero on every year
Replies
8
Views
655
waubain
waubain

Part and Inventory Search

Sponsor

Back
Top