Comments (5)
@matthiasfeist I just noticed you were looking at performance with some large file imports. I don't know how it compares to the performance you are seeing with DuckDb, but this might interest you as an alternative.
from node-gtfs.
Thanks for these details and tests.
It looks like sqlite3 recently changed the default SQLITE_MAX_VARIABLE_NUMBER from 999 to 32766. I released node-gtfs version 4.5.0 which increases the limit to 32_000 variables per insert with a substantial performance improvement!
Let me know how it works for you and if there are any other updates or suggestions that you have.
from node-gtfs.
Thanks @brendannee it works great with the update! I've probably hit programmer peek now though...I doubt I will find another 40% performance increase by changing one const any time soon 😅.
from node-gtfs.
this is awesome. DuckDB still seems a bit faster but for my usecase now the speed increase is actually good enough so I'm gonna drop all my fiddling around with a different solution :)
from node-gtfs.
Related Issues (20)
- Importing multiple feeds HOT 2
- transfers.txt default transfer_type HOT 2
- Typescript Support for node-gtfs HOT 4
- Package GTFS states MongoDB, Github States MySQL HOT 3
- Cannot use multiple databases at once HOT 2
- GTFS Fares V2 HOT 1
- GTFS Fares V2 Leg rules amount HOT 4
- [Feature Request] Create option to ignore SSL validation HOT 3
- Can I use the command line for query operations? HOT 6
- GTFS-R TripDescriptor HOT 5
- Working with Docker Database locked HOT 4
- Dropping/Clearing database HOT 1
- Deployment on errors HOT 5
- Invalid default csv parser option "relax" in import script. HOT 2
- Performance improvements HOT 4
- Possible performance improvement: DuckDB HOT 4
- Agency_id defined in agency.txt but not in routes.txt results in invalid GTFS export HOT 1
- Edge deployment and SQLite HOT 4
- Not running with Deno HOT 9
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 node-gtfs.