Re: [sqlite] what's the difference between exec and prepare-bind-step(C api)?

2008-06-16 Thread Jay A. Kreibich
On Mon, Jun 16, 2008 at 06:07:46AM -0500, John Stanton scratched on the wall: > You are expecting a miracle to ask for help without being allowed to > report the problem. > > Sqlite3_exec just encapsulates prepare and step. If your code runs > slower you have a logic error somewhere. unl

Re: [sqlite] what's the difference between exec and prepare-bind-step(C api)?

2008-06-16 Thread John Stanton
You are expecting a miracle to ask for help without being allowed to report the problem. Sqlite3_exec just encapsulates prepare and step. If your code runs slower you have a logic error somewhere. Jong-young Park wrote: > Deal all, > > I have used some SQLite application with sprintf and sqli

[sqlite] what's the difference between exec and prepare-bind-step(C api)?

2008-06-15 Thread Jong-young Park
Deal all, I have used some SQLite application with sprintf and sqlite3_exec. It takes about 1 hour. And for test, they are changed to prepare-bind-step with same logic. After that, it takes about 2 hours. I tested it on ARM board and I don't know why. Please advise me. * Sorry. I can't support