Welcome • User Guide
ToS • Privacy • Canary
Donate • Bugs • License

©2025 Poal.co

1.4K

class SubPostComment(BaseModel): cid = CharField(primary_key=True, max_length=40) content = TextField(null=True) lastedit = DateTimeField(null=True) parentcid = ForeignKeyField(db_column='parentcid', null=True, model='self', field='cid') pid = ForeignKeyField(db_column='pid', null=True, model=SubPost, field='pid') score = IntegerField(null=True) upvotes = IntegerField(default=0) downvotes = IntegerField(default=0) status = IntegerField(null=True) # 1=self delete, 2=mod delete, 0 or null=not deleted time = DateTimeField(null=True) uid = ForeignKeyField(db_column='uid', null=True, model=User, field='uid

There is no index for pid. Doesn't it will make retrievng comments for post slow.

class SubPostComment(BaseModel): cid = CharField(primary_key=True, max_length=40) content = TextField(null=True) lastedit = DateTimeField(null=True) parentcid = ForeignKeyField(db_column='parentcid', null=True, model='self', field='cid') pid = ForeignKeyField(db_column='pid', null=True, model=SubPost, field='pid') score = IntegerField(null=True) upvotes = IntegerField(default=0) downvotes = IntegerField(default=0) status = IntegerField(null=True) # 1=self delete, 2=mod delete, 0 or null=not deleted time = DateTimeField(null=True) uid = ForeignKeyField(db_column='uid', null=True, model=User, field='uid There is no index for pid. Doesn't it will make retrievng comments for post slow.

(post is archived)

You are currently inside a comment thread.
Click here to see all the comments (7).
[–] • 0 pt

Poal doesn't use SQL (anymore), and your questions aren't directly related to poal dev, but Peewee and SQL.

I would suggest you to post your questions in