Howdy, Stranger!
We are about to switch to a new forum software. Until then we have removed the registration on this forum.
Categories
- All Categories 25.7K
- Announcements & Guidelines 13
- Common Questions 30
- Using Processing 22.1K
- Programming Questions 12.2K
- Questions about Code 6.4K
- How To... 4.2K
- Hello Processing 72
- GLSL / Shaders 292
- Library Questions 4K
- Hardware, Integration & Other Languages 2.7K
- Kinect 668
- Arduino 1K
- Raspberry PI 188
- Questions about Modes 2K
- Android Mode 1.3K
- JavaScript Mode 413
- Python Mode 205
- Questions about Tools 100
- Espanol 5
- Developing Processing 548
- Create & Announce Libraries 211
- Create & Announce Modes 19
- Create & Announce Tools 29
- Summer of Code 2018 93
- Rails Girls Summer of Code 2017 3
- Summer of Code 2017 49
- Summer of Code 2016 4
- Summer of Code 2015 40
- Summer of Code 2014 22
- p5.js 1.6K
- p5.js Programming Questions 947
- p5.js Library Questions 315
- p5.js Development Questions 31
- General 1.4K
- Events & Opportunities 288
- General Discussion 365
In this Discussion
- mcemond November 2013
Processing / sqlite getting bogged down
I have multiple Xbee's sending info to the serial port every second. In my processing draw loop I check for a complete incoming data chunk from one of these xbee's then if that passes I run a db.execute insert into… statement so that the data I just got gets saved to my sqlite db. What I'm finding is that these repeated queries seem to be bogging down the process and there is a growing backlog of data as well as readings coming in that are skipped. How do I avoid this issue when storing data? Batch save? Crazy fast processor? export data to another format?
Currently the computer is a macbook air, sufficient I think. The xbees are series 2. DB: sqlite.
Thanks Mike
Answers
Hmm. I would have thought this would be a fairly generic issue easily explained. No one has any suggestions? Thnaks Mike