Member Avatar for Wenners

Hi,
I've imported a Visual FoxPro database to MS SQL Server 2008 and had a couple of queries;
The VFP tables used Numeric(5,0) for the Index fields, but I'm thinking of converting them to Integers in SQL Server. Is there any issues I should be aware of? A co-worker keeps telling me that Integers are "slower" to search on, which I find a bit hard to believe. I always thought that you would you use Numerics for data that requires precision, such as financial data and Integers for counters whole number id's and so on. Am I wrong or missing something?

Thanks

  • 2 Contributors
  • 1 Reply
  • 136 Views
  • 21 Hours Discussion Span
  • Latest Post Latest Post by sknake
Member Avatar for sknake

>>A co-worker keeps telling me that Integers are "slower" to search on, which I find a bit hard to believe
He's an idiot.

Integers are fine. Just be sure to index your database properly -- and this is regardless of datatype (string, integer, decimal, etc).

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.