Skip to main content
Question

numeric vs float data type performance

  • Apr 22, 2020 11:01 AM UTC
  • 1 reply
  • 12 views

yossibm

Hi,
It looks like reading the same amount of data takes twice as much time using numeric(8,4) as opposed to float (using pyodbc, reading into pandas). Is it the expected behavior?
Thanks,
Yossi

1 reply

yossibm
  • Author
  • Participating Frequently
  • Apr 22, 2020 6:59 PM UTC

found a workaround: cast to float on the select query.