. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 98 1.11 Performance Techniques . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 105 1.12 Transactions == join_query.c.id # Becomes: (t1."parent_id" = "jq"."id") 1.11 Performance Techniques This section outlines some techniques for improving performance when using peewee. 1.11.1 Avoiding N+1 queries The optimizations employed by the database when joining or executing a subquery. 1.11. Performance Techniques 105 peewee Documentation, Release 3.3.0 Peewee provides several APIs for mitigating N+1 query

Keys Traversing foreign keys Joining tables Implementing Many to Many Self-joins Performance Techniques Avoiding N+1 queries Iterating over lots of rows Speeding up Bulk Inserts Transactions Context parent == join_query.c.id # Becomes: (t1."parent_id" = "jq"."id") Performance Techniques This section outlines some techniques for improving performance when using peewee. Avoiding N+1 queries The term query. Note.delete().where(Note.person_id.in_(foo_people)).execute() More If you’re interested in learning more, check out the project source code [https://github.com/coleifer/peewee]. Hacks Collected

pragmas=(('foreign_keys', 'on'),) when you instantiate SqliteDatabase. Performing simple joins As an exercise in learning how to perform joins with Peewee, let’s write a query to print out all the tweets by “huey”. To classes used to describe a SQL AST, see the query builder API documentation. If you’re interested in learning more, you can also check out the project source code [https://github.com/coleifer/peewee]. Hacks group. For a thorough discuss of various techniques, check out my blog post Querying the top item by group with Peewee ORM [http://charlesleifer.com/blog/techniques-for-querying-lists-of- objects-and-de

namedtuples Returning Clause Foreign Keys and Joins Implementing Many to Many Self-joins Performance Techniques Query operators Three valued logic Adding user-defined operators Expressions SQL Functions SQL parent == join_query.c.id # Becomes: (t1."parent_id" = "jq"."id") Performance Techniques This section outlines some techniques for improving performance when using peewee. Avoiding N+1 queries The term classes used to describe a SQL AST, see the query builder API documentation. If you’re interested in learning more, you can also check out the project source code [https://github.com/coleifer/peewee]. Hacks

Keys Traversing foreign keys Joining tables Implementing Many to Many Self-joins Performance Techniques Avoiding N+1 queries Iterating over lots of rows Speeding up Bulk Inserts Transactions Context parent == join_query.c.id # Becomes: (t1."parent_id" = "jq"."id") Performance Techniques This section outlines some techniques for improving performance when using peewee. Avoiding N+1 queries The term classes used to describe a SQL AST, see the query builder API documentation. If you’re interested in learning more, you can also check out the project source code [https://github.com/coleifer/peewee]. Hacks

Keys Traversing foreign keys Joining tables Implementing Many to Many Self-joins Performance Techniques Avoiding N+1 queries Iterating over lots of rows Speeding up Bulk Inserts Transactions Context parent == join_query.c.id # Becomes: (t1."parent_id" = "jq"."id") Performance Techniques This section outlines some techniques for improving performance when using peewee. Avoiding N+1 queries The term classes used to describe a SQL AST, see the query builder API documentation. If you’re interested in learning more, you can also check out the project source code [https://github.com/coleifer/peewee]. Hacks

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 99 1.11 Performance Techniques . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 106 1.12 Transactions == join_query.c.id # Becomes: (t1."parent_id" = "jq"."id") 1.11 Performance Techniques This section outlines some techniques for improving performance when using peewee. 106 Chapter 1. Contents: peewee method is usually faster but will involve a query for each table being selected. 1.11. Performance Techniques 107 peewee Documentation, Release 3.4.0 Using prefetch peewee supports pre-fetching related

join_query.c.id # Becomes: (t1."parent_id" = "jq"."id") 1.7.22 Performance Techniques This section outlines some techniques for improving performance when using peewee. 1.7. Querying 81 peewee Documentation classes used to describe a SQL AST, see the query builder API documentation. If you’re interested in learning more, you can also check out the project source code. 258 Chapter 1. Contents: peewee Documentation describe several ways to query the single top item per group. For a thorough discuss of various techniques, check out my blog post Querying the top item by group with Peewee ORM. If you are interested in

'on'),) when you instantiate SqliteDatabase. 1.9.2 Performing simple joins As an exercise in learning how to perform joins with Peewee, let’s write a query to print out all the tweets by “huey”. To classes used to describe a SQL AST, see the query builder API documentation. If you’re interested in learning more, you can also check out the project source code. 1.15 Hacks Collected hacks using peewee describe several ways to query the single top item per group. For a thorough discuss of various techniques, check out my blog post Querying the top item by group with Peewee ORM. If you are interested in

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 68 1.11 Performance Techniques . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 74 1.12 Transactions web frameworks, see the Adding Request Hooks section. Note: For advanced connection management techniques, see the advanced connection management section. To use this database with your models, set the == join_query.c.id # Becomes: (t1."parent_id" = "jq"."id") 1.11 Performance Techniques This section outlines some techniques for improving performance when using peewee. 1.11.1 Avoiding N+1 queries The