1 Reply Latest reply: Oct 4, 2008 7:30 AM by blazespinnaker
David Dennis Level 1 Level 1 (45 points)
Consider this simple line of code:

sqlite3_exec(database, "update events set used = 0", NULL, NULL, NULL);

The events table contains about 50 records. I would expect this query to execute in very little time and use very little memory. It is just updating one field, without even a condition.

As you may know, the SQLite documentation claims that the sqlite3_exec function prepares, runs and destroys the query, therefore taking little to no net memory.

What actually happens, according to Instruments, is that this query takes more than 30k of memory in 318 separate objects and never releases them - the objects remain active until the program terminates.

The really long list below this message is the Instruments output that is associated with this single statement.

Can someone tell me what's going on, and if there is any way to execute this type of statement without so much overhead?

Many thanks.

D

# Object Address Category Creation Time Size Responsible Library Responsible Caller
4169 0x2480d0 GeneralBlock-16 00:04.027 16 libsqlite3.0.dylib sqlite3StartTable
4170 0x2480e0 GeneralBlock-80 00:04.027 80 libsqlite3.0.dylib sqlite3StartTable
4171 0x248130 GeneralBlock-16 00:04.027 16 libsqlite3.0.dylib sqlite3AddColumn
4172 0x248140 GeneralBlock-160 00:04.027 160 libsqlite3.0.dylib sqlite3Realloc
4173 0x2481e0 GeneralBlock-16 00:04.027 16 libsqlite3.0.dylib yy_reduce
4174 0x2481f0 GeneralBlock-16 00:04.027 16 libsqlite3.0.dylib sqlite3AddColumn
4175 0x248200 GeneralBlock-16 00:04.027 16 libsqlite3.0.dylib yy_reduce
4176 0x248210 GeneralBlock-16 00:04.027 16 libsqlite3.0.dylib sqlite3AddColumn
4177 0x248220 GeneralBlock-16 00:04.027 16 libsqlite3.0.dylib yy_reduce
4178 0x248230 GeneralBlock-16 00:04.027 16 libsqlite3.0.dylib sqlite3AddColumn
4179 0x248240 GeneralBlock-16 00:04.027 16 libsqlite3.0.dylib yy_reduce
4180 0x248250 GeneralBlock-16 00:04.027 16 libsqlite3.0.dylib sqlite3AddColumn
4181 0x248260 GeneralBlock-16 00:04.027 16 libsqlite3.0.dylib yy_reduce
4182 0x248270 GeneralBlock-32 00:04.027 32 libsqlite3.0.dylib sqlite3MallocX
4183 0x824200 GeneralBlock-1024 00:04.029 1024 libsqlite3.0.dylib sqlite3PagerAcquire
4184 0x823a00 GeneralBlock-1536 00:04.029 1536 libsqlite3.0.dylib sqlite3PagerAcquire
4185 0x825e00 GeneralBlock-1536 00:04.031 1536 libsqlite3.0.dylib sqlite3PagerAcquire
4186 0x2485b0 GeneralBlock-16 00:04.034 16 libsqlite3.0.dylib sqlite3StartTable
4187 0x248790 GeneralBlock-80 00:04.034 80 libsqlite3.0.dylib sqlite3StartTable
4188 0x248490 GeneralBlock-16 00:04.034 16 libsqlite3.0.dylib sqlite3AddColumn
4189 0x2484a0 GeneralBlock-16 00:04.034 16 libsqlite3.0.dylib yy_reduce
4190 0x2488d0 GeneralBlock-96 00:04.034 96 libsqlite3.0.dylib sqlite3CreateIndex
4191 0x248930 GeneralBlock-32 00:04.034 32 libsqlite3.0.dylib sqlite3MallocX
4192 0x248880 GeneralBlock-16 00:04.035 16 libsqlite3.0.dylib sqlite3AddColumn
4193 0x248890 GeneralBlock-16 00:04.035 16 libsqlite3.0.dylib yy_reduce
4194 0x2488a0 GeneralBlock-16 00:04.035 16 libsqlite3.0.dylib sqlite3AddColumn
4195 0x2488b0 GeneralBlock-16 00:04.035 16 libsqlite3.0.dylib yy_reduce
4196 0x2488c0 GeneralBlock-16 00:04.035 16 libsqlite3.0.dylib sqlite3AddColumn
4197 0x248990 GeneralBlock-16 00:04.035 16 libsqlite3.0.dylib yy_reduce
4198 0x2489a0 GeneralBlock-16 00:04.035 16 libsqlite3.0.dylib sqlite3AddColumn
4199 0x2489b0 GeneralBlock-16 00:04.035 16 libsqlite3.0.dylib yy_reduce
4200 0x2489c0 GeneralBlock-16 00:04.035 16 libsqlite3.0.dylib sqlite3AddColumn
4201 0x2489d0 GeneralBlock-16 00:04.035 16 libsqlite3.0.dylib yy_reduce
4202 0x2489e0 GeneralBlock-16 00:04.035 16 libsqlite3.0.dylib sqlite3AddColumn
4203 0x2489f0 GeneralBlock-16 00:04.035 16 libsqlite3.0.dylib yy_reduce
4204 0x248a00 GeneralBlock-16 00:04.035 16 libsqlite3.0.dylib sqlite3AddColumn
4205 0x248a10 GeneralBlock-16 00:04.035 16 libsqlite3.0.dylib yy_reduce
4206 0x248a20 GeneralBlock-16 00:04.035 16 libsqlite3.0.dylib sqlite3AddColumn
4207 0x248a30 GeneralBlock-320 00:04.035 320 libsqlite3.0.dylib sqlite3Realloc
4208 0x2484b0 GeneralBlock-16 00:04.035 16 libsqlite3.0.dylib yy_reduce
4209 0x2484c0 GeneralBlock-16 00:04.035 16 libsqlite3.0.dylib sqlite3AddColumn
4210 0x248b70 GeneralBlock-16 00:04.035 16 libsqlite3.0.dylib yy_reduce
4211 0x248b80 GeneralBlock-16 00:04.035 16 libsqlite3.0.dylib sqlite3AddColumn
4212 0x248b90 GeneralBlock-16 00:04.036 16 libsqlite3.0.dylib yy_reduce
4213 0x248bf0 GeneralBlock-80 00:04.036 80 libsqlite3.0.dylib sqlite3ExprDup
4214 0x248c40 GeneralBlock-16 00:04.036 16 libsqlite3.0.dylib sqlite3ExprDup
4215 0x248c50 GeneralBlock-16 00:04.036 16 libsqlite3.0.dylib sqlite3AddDefaultValue
4216 0x2487e0 GeneralBlock-16 00:04.036 16 libsqlite3.0.dylib sqlite3AddColumn
4217 0x2487f0 GeneralBlock-16 00:04.036 16 libsqlite3.0.dylib yy_reduce
4218 0x248800 GeneralBlock-32 00:04.036 32 libsqlite3.0.dylib sqlite3MallocX
4219 0x248820 GeneralBlock-16 00:04.037 16 libsqlite3.0.dylib sqlite3StartTable
4220 0x248ba0 GeneralBlock-80 00:04.037 80 libsqlite3.0.dylib sqlite3StartTable
4221 0x248830 GeneralBlock-16 00:04.037 16 libsqlite3.0.dylib sqlite3AddColumn
4222 0x248c60 GeneralBlock-160 00:04.037 160 libsqlite3.0.dylib sqlite3Realloc
4223 0x248840 GeneralBlock-32 00:04.037 32 libsqlite3.0.dylib yy_reduce
4224 0x248d00 GeneralBlock-96 00:04.037 96 libsqlite3.0.dylib sqlite3CreateIndex
4225 0x248470 GeneralBlock-32 00:04.037 32 libsqlite3.0.dylib sqlite3MallocX
4226 0x248420 GeneralBlock-16 00:04.038 16 libsqlite3.0.dylib sqlite3AddColumn
4227 0x248430 GeneralBlock-16 00:04.038 16 libsqlite3.0.dylib yy_reduce
4228 0x248440 GeneralBlock-16 00:04.038 16 libsqlite3.0.dylib sqlite3AddColumn
4229 0x248450 GeneralBlock-16 00:04.038 16 libsqlite3.0.dylib yy_reduce
4230 0x248460 GeneralBlock-16 00:04.038 16 libsqlite3.0.dylib sqlite3AddColumn
4231 0x248d60 GeneralBlock-16 00:04.038 16 libsqlite3.0.dylib yy_reduce
4232 0x248d70 GeneralBlock-16 00:04.038 16 libsqlite3.0.dylib sqlite3AddColumn
4233 0x248d80 GeneralBlock-16 00:04.038 16 libsqlite3.0.dylib yy_reduce
4234 0x248d90 GeneralBlock-16 00:04.038 16 libsqlite3.0.dylib sqlite3AddColumn
4235 0x248da0 GeneralBlock-16 00:04.038 16 libsqlite3.0.dylib yy_reduce
4236 0x248db0 GeneralBlock-16 00:04.038 16 libsqlite3.0.dylib sqlite3AddColumn
4237 0x248dc0 GeneralBlock-16 00:04.038 16 libsqlite3.0.dylib yy_reduce
4238 0x248860 GeneralBlock-32 00:04.038 32 libsqlite3.0.dylib sqlite3MallocX
4239 0x248dd0 GeneralBlock-16 00:04.039 16 libsqlite3.0.dylib sqlite3StartTable
4240 0x248de0 GeneralBlock-80 00:04.039 80 libsqlite3.0.dylib sqlite3StartTable
4241 0x248e30 GeneralBlock-16 00:04.039 16 libsqlite3.0.dylib sqlite3AddColumn
4242 0x248e40 GeneralBlock-160 00:04.039 160 libsqlite3.0.dylib sqlite3Realloc
4243 0x248ee0 GeneralBlock-16 00:04.039 16 libsqlite3.0.dylib yy_reduce
4244 0x248f60 GeneralBlock-96 00:04.040 96 libsqlite3.0.dylib sqlite3CreateIndex
4245 0x248fd0 GeneralBlock-32 00:04.040 32 libsqlite3.0.dylib sqlite3MallocX
4246 0x248fc0 GeneralBlock-16 00:04.040 16 libsqlite3.0.dylib sqlite3AddColumn
4247 0x248f10 GeneralBlock-16 00:04.040 16 libsqlite3.0.dylib yy_reduce
4248 0x248f20 GeneralBlock-16 00:04.040 16 libsqlite3.0.dylib sqlite3AddColumn
4249 0x248f30 GeneralBlock-16 00:04.040 16 libsqlite3.0.dylib yy_reduce
4250 0x248f40 GeneralBlock-16 00:04.040 16 libsqlite3.0.dylib sqlite3AddColumn
4251 0x248f50 GeneralBlock-16 00:04.040 16 libsqlite3.0.dylib yy_reduce
4252 0x248ff0 GeneralBlock-16 00:04.040 16 libsqlite3.0.dylib sqlite3AddColumn
4253 0x249000 GeneralBlock-16 00:04.040 16 libsqlite3.0.dylib yy_reduce
4254 0x249010 GeneralBlock-16 00:04.040 16 libsqlite3.0.dylib sqlite3AddColumn
4255 0x249020 GeneralBlock-16 00:04.040 16 libsqlite3.0.dylib yy_reduce
4256 0x248ef0 GeneralBlock-32 00:04.040 32 libsqlite3.0.dylib sqlite3MallocX
4257 0x826800 GeneralBlock-1536 00:04.041 1536 libsqlite3.0.dylib sqlite3PagerAcquire
4258 0x2490c0 GeneralBlock-16 00:04.044 16 libsqlite3.0.dylib sqlite3StartTable
4259 0x2490d0 GeneralBlock-80 00:04.044 80 libsqlite3.0.dylib sqlite3StartTable
4260 0x249120 GeneralBlock-16 00:04.044 16 libsqlite3.0.dylib sqlite3AddColumn
4261 0x2491c0 GeneralBlock-160 00:04.044 160 libsqlite3.0.dylib sqlite3Realloc
4262 0x249130 GeneralBlock-32 00:04.044 32 libsqlite3.0.dylib yy_reduce
4263 0x249260 GeneralBlock-96 00:04.044 96 libsqlite3.0.dylib sqlite3CreateIndex
4264 0x2492c0 GeneralBlock-32 00:04.044 32 libsqlite3.0.dylib sqlite3MallocX
4265 0x249170 GeneralBlock-16 00:04.045 16 libsqlite3.0.dylib sqlite3AddColumn
4266 0x249180 GeneralBlock-16 00:04.045 16 libsqlite3.0.dylib yy_reduce
4267 0x249190 GeneralBlock-16 00:04.045 16 libsqlite3.0.dylib sqlite3AddColumn
4268 0x2491a0 GeneralBlock-16 00:04.045 16 libsqlite3.0.dylib yy_reduce
4269 0x2491b0 GeneralBlock-16 00:04.045 16 libsqlite3.0.dylib sqlite3AddColumn
4270 0x248370 GeneralBlock-16 00:04.045 16 libsqlite3.0.dylib yy_reduce
4271 0x248380 GeneralBlock-16 00:04.045 16 libsqlite3.0.dylib sqlite3AddColumn
4272 0x248390 GeneralBlock-16 00:04.045 16 libsqlite3.0.dylib yy_reduce
4273 0x249150 GeneralBlock-32 00:04.045 32 libsqlite3.0.dylib sqlite3MallocX
4274 0x249030 GeneralBlock-16 00:04.046 16 libsqlite3.0.dylib sqlite3StartTable
4275 0x249040 GeneralBlock-80 00:04.046 80 libsqlite3.0.dylib sqlite3StartTable
4276 0x249090 GeneralBlock-16 00:04.046 16 libsqlite3.0.dylib sqlite3AddColumn
4277 0x2492e0 GeneralBlock-160 00:04.046 160 libsqlite3.0.dylib sqlite3Realloc
4278 0x2490a0 GeneralBlock-16 00:04.046 16 libsqlite3.0.dylib yy_reduce
4279 0x2490b0 GeneralBlock-16 00:04.046 16 libsqlite3.0.dylib sqlite3AddColumn
4280 0x249380 GeneralBlock-16 00:04.046 16 libsqlite3.0.dylib yy_reduce
4281 0x249390 GeneralBlock-16 00:04.047 16 libsqlite3.0.dylib sqlite3AddColumn
4282 0x2493a0 GeneralBlock-16 00:04.047 16 libsqlite3.0.dylib yy_reduce
4283 0x2493b0 GeneralBlock-16 00:04.047 16 libsqlite3.0.dylib sqlite3AddColumn
4284 0x2493c0 GeneralBlock-16 00:04.047 16 libsqlite3.0.dylib yy_reduce
4285 0x2493d0 GeneralBlock-16 00:04.047 16 libsqlite3.0.dylib sqlite3AddColumn
4286 0x2493e0 GeneralBlock-16 00:04.047 16 libsqlite3.0.dylib yy_reduce
4287 0x2483a0 GeneralBlock-32 00:04.047 32 libsqlite3.0.dylib sqlite3MallocX
4288 0x249480 GeneralBlock-32 00:04.048 32 libsqlite3.0.dylib sqlite3StartTable
4289 0x2494a0 GeneralBlock-80 00:04.048 80 libsqlite3.0.dylib sqlite3StartTable
4290 0x2494f0 GeneralBlock-32 00:04.048 32 libsqlite3.0.dylib sqlite3AddColumn
4291 0x249570 GeneralBlock-160 00:04.048 160 libsqlite3.0.dylib sqlite3Realloc
4292 0x249510 GeneralBlock-16 00:04.048 16 libsqlite3.0.dylib sqlite3AddColumn
4293 0x249520 GeneralBlock-16 00:04.048 16 libsqlite3.0.dylib yy_reduce
4294 0x249530 GeneralBlock-32 00:04.048 32 libsqlite3.0.dylib sqlite3AddColumn
4295 0x249550 GeneralBlock-16 00:04.048 16 libsqlite3.0.dylib yy_reduce
4296 0x249560 GeneralBlock-16 00:04.048 16 libsqlite3.0.dylib sqlite3AddColumn
4297 0x249610 GeneralBlock-16 00:04.048 16 libsqlite3.0.dylib yy_reduce
4298 0x249620 GeneralBlock-16 00:04.048 16 libsqlite3.0.dylib sqlite3AddColumn
4299 0x249630 GeneralBlock-16 00:04.048 16 libsqlite3.0.dylib yy_reduce
4300 0x249640 GeneralBlock-32 00:04.048 32 libsqlite3.0.dylib sqlite3MallocX
4301 0x2483c0 GeneralBlock-16 00:04.049 16 libsqlite3.0.dylib sqlite3StartTable
4302 0x2483d0 GeneralBlock-80 00:04.049 80 libsqlite3.0.dylib sqlite3StartTable
4303 0x249660 GeneralBlock-16 00:04.049 16 libsqlite3.0.dylib sqlite3AddColumn
4304 0x249710 GeneralBlock-16 00:04.049 16 libsqlite3.0.dylib yy_reduce
4305 0x249720 GeneralBlock-16 00:04.049 16 libsqlite3.0.dylib sqlite3AddColumn
4306 0x249730 GeneralBlock-16 00:04.049 16 libsqlite3.0.dylib yy_reduce
4307 0x249740 GeneralBlock-16 00:04.049 16 libsqlite3.0.dylib sqlite3AddColumn
4308 0x249750 GeneralBlock-16 00:04.050 16 libsqlite3.0.dylib yy_reduce
4309 0x249760 GeneralBlock-16 00:04.050 16 libsqlite3.0.dylib sqlite3AddColumn
4310 0x249770 GeneralBlock-16 00:04.050 16 libsqlite3.0.dylib yy_reduce
4311 0x249780 GeneralBlock-16 00:04.050 16 libsqlite3.0.dylib sqlite3AddColumn
4312 0x249790 GeneralBlock-16 00:04.050 16 libsqlite3.0.dylib yy_reduce
4313 0x2497a0 GeneralBlock-16 00:04.050 16 libsqlite3.0.dylib sqlite3AddColumn
4314 0x2497b0 GeneralBlock-16 00:04.050 16 libsqlite3.0.dylib yy_reduce
4315 0x249960 GeneralBlock-16 00:04.050 16 libsqlite3.0.dylib sqlite3AddColumn
4316 0x249970 GeneralBlock-16 00:04.050 16 libsqlite3.0.dylib yy_reduce
4317 0x249980 GeneralBlock-16 00:04.050 16 libsqlite3.0.dylib sqlite3AddColumn
4318 0x249990 GeneralBlock-16 00:04.050 16 libsqlite3.0.dylib sqlite3AddColumn
4319 0x2493f0 GeneralBlock-16 00:04.050 16 libsqlite3.0.dylib sqlite3AddColumn
4320 0x249400 GeneralBlock-16 00:04.050 16 libsqlite3.0.dylib sqlite3AddColumn
4321 0x249410 GeneralBlock-16 00:04.050 16 libsqlite3.0.dylib sqlite3AddColumn
4322 0x249420 GeneralBlock-16 00:04.050 16 libsqlite3.0.dylib sqlite3AddColumn
4323 0x249430 GeneralBlock-16 00:04.050 16 libsqlite3.0.dylib yy_reduce
4324 0x249440 GeneralBlock-16 00:04.050 16 libsqlite3.0.dylib sqlite3AddColumn
4325 0x249450 GeneralBlock-16 00:04.050 16 libsqlite3.0.dylib yy_reduce
4326 0x249460 GeneralBlock-16 00:04.051 16 libsqlite3.0.dylib sqlite3AddColumn
4327 0x249470 GeneralBlock-16 00:04.051 16 libsqlite3.0.dylib yy_reduce
4328 0x249ae0 GeneralBlock-16 00:04.051 16 libsqlite3.0.dylib sqlite3AddColumn
4329 0x249af0 GeneralBlock-16 00:04.051 16 libsqlite3.0.dylib yy_reduce
4330 0x249b00 GeneralBlock-16 00:04.051 16 libsqlite3.0.dylib sqlite3AddColumn
4331 0x249b10 GeneralBlock-480 00:04.051 480 libsqlite3.0.dylib sqlite3Realloc
4332 0x2499a0 GeneralBlock-16 00:04.051 16 libsqlite3.0.dylib yy_reduce
4333 0x2499b0 GeneralBlock-16 00:04.051 16 libsqlite3.0.dylib sqlite3AddColumn
4334 0x2499c0 GeneralBlock-16 00:04.051 16 libsqlite3.0.dylib yy_reduce
4335 0x2499d0 GeneralBlock-16 00:04.051 16 libsqlite3.0.dylib sqlite3AddColumn
4336 0x2499e0 GeneralBlock-16 00:04.051 16 libsqlite3.0.dylib yy_reduce
4337 0x2499f0 GeneralBlock-16 00:04.051 16 libsqlite3.0.dylib sqlite3AddColumn
4338 0x249a00 GeneralBlock-16 00:04.051 16 libsqlite3.0.dylib yy_reduce
4339 0x249a10 GeneralBlock-16 00:04.051 16 libsqlite3.0.dylib sqlite3AddColumn
4340 0x249a20 GeneralBlock-16 00:04.051 16 libsqlite3.0.dylib yy_reduce
4341 0x249a30 GeneralBlock-16 00:04.051 16 libsqlite3.0.dylib sqlite3AddColumn
4342 0x249a40 GeneralBlock-16 00:04.051 16 libsqlite3.0.dylib yy_reduce
4343 0x249a50 GeneralBlock-16 00:04.051 16 libsqlite3.0.dylib sqlite3AddColumn
4344 0x249a60 GeneralBlock-16 00:04.051 16 libsqlite3.0.dylib yy_reduce
4345 0x249a70 GeneralBlock-16 00:04.051 16 libsqlite3.0.dylib sqlite3AddColumn
4346 0x249a80 GeneralBlock-16 00:04.052 16 libsqlite3.0.dylib yy_reduce
4347 0x249a90 GeneralBlock-32 00:04.052 32 libsqlite3.0.dylib sqlite3MallocX
4348 0x824600 GeneralBlock-1536 00:04.052 1536 libsqlite3.0.dylib sqlite3PagerAcquire
4349 0x249ab0 GeneralBlock-16 00:04.053 16 libsqlite3.0.dylib sqlite3StartTable
4350 0x249ec0 GeneralBlock-80 00:04.053 80 libsqlite3.0.dylib sqlite3StartTable
4351 0x249ac0 GeneralBlock-16 00:04.053 16 libsqlite3.0.dylib sqlite3AddColumn
4352 0x249ad0 GeneralBlock-16 00:04.053 16 libsqlite3.0.dylib yy_reduce
4353 0x249f10 GeneralBlock-16 00:04.053 16 libsqlite3.0.dylib sqlite3AddColumn
4354 0x249f20 GeneralBlock-16 00:04.053 16 libsqlite3.0.dylib yy_reduce
4355 0x249f30 GeneralBlock-16 00:04.053 16 libsqlite3.0.dylib sqlite3AddColumn
4356 0x249f40 GeneralBlock-16 00:04.053 16 libsqlite3.0.dylib yy_reduce
4357 0x249f50 GeneralBlock-16 00:04.053 16 libsqlite3.0.dylib sqlite3AddColumn
4358 0x2497c0 GeneralBlock-16 00:04.053 16 libsqlite3.0.dylib yy_reduce
4359 0x2497d0 GeneralBlock-16 00:04.053 16 libsqlite3.0.dylib sqlite3AddColumn
4360 0x2497e0 GeneralBlock-16 00:04.053 16 libsqlite3.0.dylib yy_reduce
4361 0x2497f0 GeneralBlock-16 00:04.053 16 libsqlite3.0.dylib sqlite3AddColumn
4362 0x249800 GeneralBlock-16 00:04.071 16 libsqlite3.0.dylib yy_reduce
4363 0x249810 GeneralBlock-16 00:04.071 16 libsqlite3.0.dylib sqlite3AddColumn
4364 0x249820 GeneralBlock-16 00:04.071 16 libsqlite3.0.dylib yy_reduce
4365 0x249830 GeneralBlock-16 00:04.071 16 libsqlite3.0.dylib sqlite3AddColumn
4366 0x249840 GeneralBlock-16 00:04.071 16 libsqlite3.0.dylib yy_reduce
4367 0x249850 GeneralBlock-16 00:04.071 16 libsqlite3.0.dylib sqlite3AddColumn
4368 0x249860 GeneralBlock-16 00:04.071 16 libsqlite3.0.dylib yy_reduce
4369 0x249870 GeneralBlock-16 00:04.072 16 libsqlite3.0.dylib sqlite3AddColumn
4370 0x249880 GeneralBlock-16 00:04.072 16 libsqlite3.0.dylib yy_reduce
4371 0x249890 GeneralBlock-16 00:04.072 16 libsqlite3.0.dylib sqlite3AddColumn
4372 0x2498a0 GeneralBlock-16 00:04.072 16 libsqlite3.0.dylib yy_reduce
4373 0x2498b0 GeneralBlock-16 00:04.072 16 libsqlite3.0.dylib sqlite3AddColumn
4374 0x2498c0 GeneralBlock-16 00:04.072 16 libsqlite3.0.dylib yy_reduce
4375 0x2498d0 GeneralBlock-16 00:04.072 16 libsqlite3.0.dylib sqlite3AddColumn
4376 0x2498e0 GeneralBlock-16 00:04.072 16 libsqlite3.0.dylib yy_reduce
4377 0x2498f0 GeneralBlock-16 00:04.072 16 libsqlite3.0.dylib sqlite3AddColumn
4378 0x249900 GeneralBlock-16 00:04.072 16 libsqlite3.0.dylib yy_reduce
4379 0x249910 GeneralBlock-16 00:04.072 16 libsqlite3.0.dylib sqlite3AddColumn
4380 0x249920 GeneralBlock-16 00:04.072 16 libsqlite3.0.dylib yy_reduce
4381 0x249930 GeneralBlock-16 00:04.072 16 libsqlite3.0.dylib sqlite3AddColumn
4382 0x249940 GeneralBlock-16 00:04.072 16 libsqlite3.0.dylib yy_reduce
4383 0x249950 GeneralBlock-16 00:04.072 16 libsqlite3.0.dylib sqlite3AddColumn
4384 0x249f60 GeneralBlock-16 00:04.072 16 libsqlite3.0.dylib yy_reduce
4385 0x249f70 GeneralBlock-16 00:04.072 16 libsqlite3.0.dylib sqlite3AddColumn
4386 0x249f80 GeneralBlock-16 00:04.072 16 libsqlite3.0.dylib yy_reduce
4387 0x249f90 GeneralBlock-16 00:04.072 16 libsqlite3.0.dylib sqlite3AddColumn

MacBook Pro 2.4ghz; iPhone with version 2.0 software, Mac OS X (10.5.4)