Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2006
    Posts
    3

    Question Unanswered: Numeric Vs bigint

    Hi,

    Issue: Storing 64bit Integer in the db.

    We are running on 12.5.3 and the only way (correct me if I am wrong) I can do this is numeric(16,0).

    I was wondering is it worth upgrading to ASE-15 just for the bigint datatype?

    is there significant performance gain in using bigint vs numeric datatype?

    I would appriciate if someone can help me with this.


    Thanks,
    RT

  2. #2
    Join Date
    Jan 2003
    Location
    Geneva, Switzerland
    Posts
    353
    I don't think that you'd see any significant performance improvement simply due to switching between BIGINT and NUMERIC(16,0).

    There could be other reasons to move to 15 of couse, such as the new optimizer, better partitionning, etc...

    Michael

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •