Comments (7)
I have an idea how to improve BenchmarkPgSelectMultipleRowsPrepared
and BenchmarkPgSelectMultipleRowsUnprepared
(base on fields that bypass a lot reflect work: https://github.com/vmihailenco/msgpack/blob/master/typeinfo.go#L20). BenchmarkRawSelectMultipleRowsPrepared
looks like a cheating and TBH I don't understand what it does. The rest of benchmarks looks good :)
from pg.
Well, it's documented that the raw
methods are basically cheating in order to determine a lower bound to the attainable results. Pretty clever: https://github.com/jackc/go_db_bench
from pg.
What I found so far is that changing people
to:
type People []person
func (people *People) New() interface{} {
pp := *people
pp = append(pp, person{})
return &pp[len(pp)-1]
}
makes some benchmarks almost 30-40% faster. So I guess it is possible to write such benchmarks where go-pg
will be much faster...
from pg.
I've actually always wondered why you used slices of pointers instead of just slices. Good to know!
from pg.
Wait, shouldn't it be:
type People []person
func (people *People) New() interface{} {
p := person{}
*people = append(*people,p)
return &p
}
Because otherwise you append to a new slice (which refers to the same memory, which might get reallocated), and the old slice doesn't get updated.
Unless I'm misunderstanding something.
from pg.
Disregard me, that didn't work because it returned a copy of person{}
... ugh. This is the corrected version:
*people = append(*people, person{})
dpeople := *people
return &dpeople[len(dpeople)-1]
What do you think?
from pg.
I consider this fixed by jackc/go_db_bench#2. go-pg is still slightly slower, but that is the cost of using reflect.
from pg.
Related Issues (20)
- Error in join query not erroring Select call
- CreateTable method not accepting CreateTableOptions struct HOT 4
- How do you change which field/column in the base table is referenced by the foreign key of a sub table?
- 42703 column does not exist, only for multi-word columns on one table
- Update omit zero when no fields produces invalid syntax HOT 1
- panic on non nil "Result" with nil value in "AfterQuery" hook
- "BeforeUpdate" hook not working for individual column updates
- CountEstimate is not safe to be called from transaction context
- nil-pointer dereference in getConn HOT 3
- conn.OnQueryProcessed undefined (type *pg.DB has no field or method OnQueryProcessed) HOT 1
- Only one of the Columns that have the same name parsed in map[string]interface{} HOT 1
- Open does not return Error when connection fails HOT 1
- r.db.RunInTransaction can not use r.db.ModelContext
- Do we support select to insert HOT 1
- Join() being ignored when using Delete() HOT 3
- Help me to get the relation.
- Scan JSON value get panic HOT 1
- Unable to insert a value of type uint64 into the table column of type DECIMAL(20,0).
- Potential Memory Leak in appendRune Function
- Multiple joins not deserializing correctly
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from pg.