Open Closed

ABP Entity and Database #207


User avatar
0
vishalnikam created

Check the docs before asking a question: https://docs.abp.io/en/commercial/latest/ Check the samples, to see the basic tasks: https://docs.abp.io/en/commercial/latest/samples/index The exact solution to your question may have been answered before, please use the search on the homepage.

  • ABP Framework version: v2.7.0
  • UI type: Angular
  • Tiered (MVC) or Identity Server Seperated (Angular): yes
  • Exception message and stack trace: NA
  • Steps to reproduce the issue: NA

Why ABP framwork database\entity has guid(uniqueidentifier) as primary key and not big int or int. what is best practice and performace implication on database as it keep growing.


1 Answer(s)
  • User Avatar
    0
    liangshiwei created
    Support Team Fullstack Developer

    See https://dba.stackexchange.com/questions/264/guid-vs-int-which-is-better-as-a-primary-key.

    ABP use sequential GUID, It is good for indexing.

Boost Your Development
ABP Live Training
Packages
See Trainings
Mastering ABP Framework Book
The Official Guide
Mastering
ABP Framework
Learn More
Mastering ABP Framework Book
Made with ❤️ on ABP v10.0.0-preview. Updated on June 20, 2025, 11:20