Re: [sqlite] Insert delay!
Cesar David Rodas Maldonado wrote: Yeah John I am studying Math and computer science (but i am in the first year, and this is very boring) in National University Of Paraguay. When I finish my idea i will share my code. Thanks For understand my English John! On 8/5/06, John Stanton <[EMAIL PROTECTED]> wrote: Cesar David Rodas Maldonado wrote: > I was thinking a lot in the next month in how can I do the delay insert and > I found something for do that, is basic because I don't have a lot of > knowledge, I'm just start the University. > > OK, I need with SQLite to select all the time as possible, and delay the > Insert, I don't care the time that took insert something. These is my > needs with SQLite. Is something Interesting on my idea? If there is one I > will share my idea. > Your English is not very clear, but as I understand your idea it could be realized by performing your INSERTs in a thread, ideally set to a low priority and fed from a FIFO queue. You need to be aware of the locking constraints. Have success with your studies. Are you studying Math and Computer Science? You are welcome. I look forward to seeing your code. Math and CS can be very exciting, so stick at it. I have a daughter who has been studying Math and Computer Science and is now in an cutting edge PhD program and very happy. The best is yet to come for you.
Re: [sqlite] Insert delay!
Yeah John I am studying Math and computer science (but i am in the first year, and this is very boring) in National University Of Paraguay. When I finish my idea i will share my code. Thanks For understand my English John! On 8/5/06, John Stanton <[EMAIL PROTECTED]> wrote: Cesar David Rodas Maldonado wrote: > I was thinking a lot in the next month in how can I do the delay insert and > I found something for do that, is basic because I don't have a lot of > knowledge, I'm just start the University. > > OK, I need with SQLite to select all the time as possible, and delay the > Insert, I don't care the time that took insert something. These is my > needs with SQLite. Is something Interesting on my idea? If there is one I > will share my idea. > Your English is not very clear, but as I understand your idea it could be realized by performing your INSERTs in a thread, ideally set to a low priority and fed from a FIFO queue. You need to be aware of the locking constraints. Have success with your studies. Are you studying Math and Computer Science?
Re: [sqlite] Insert delay!
Cesar David Rodas Maldonado wrote: I was thinking a lot in the next month in how can I do the delay insert and I found something for do that, is basic because I don't have a lot of knowledge, I'm just start the University. OK, I need with SQLite to select all the time as possible, and delay the Insert, I don't care the time that took insert something. These is my needs with SQLite. Is something Interesting on my idea? If there is one I will share my idea. Your English is not very clear, but as I understand your idea it could be realized by performing your INSERTs in a thread, ideally set to a low priority and fed from a FIFO queue. You need to be aware of the locking constraints. Have success with your studies. Are you studying Math and Computer Science?
Re: [sqlite] Insert delay!
Your all right! what i am doing right know is cache the insert query and execute when the is not select, and that is almost working. When i was developing my "insert delay" I thought that will be great is SQLite support an option like MySQL (insert delay). And i dont wanna use Postgresql, cause this is client-server, I like SQLite, and with my "insert delay" SQLite for me is more useful than postgresql On 8/5/06, Clay Dowling <[EMAIL PROTECTED]> wrote: Cesar David Rodas Maldonado wrote: > I was thinking a lot in the next month in how can I do the delay insert and > I found something for do that, is basic because I don't have a lot of > knowledge, I'm just start the University. > > OK, I need with SQLite to select all the time as possible, and delay the > Insert, I don't care the time that took insert something. These is my > needs with SQLite. Is something Interesting on my idea? If there is one I > will share my idea. If you're trying to save your inserts until your app has some idle time, the best technique I can come up with is to cache those inserts in your application. When your activity monitoring thread detects that there is no other database activity it can fire off a process to perform the inserts. That keeps your app very responsive to user queries. If you find that you need a higher degree of concurrency you might consider PostgreSQL. But you'll probably be okay with SQLite as long as your app can find the time to run the inserts often enough. Clay -- http://www.lazarusid.com/notes/ Lazarus Notes Articles and Commentary on Web Development
Re: [sqlite] Insert delay!
Cesar David Rodas Maldonado wrote: I was thinking a lot in the next month in how can I do the delay insert and I found something for do that, is basic because I don't have a lot of knowledge, I'm just start the University. OK, I need with SQLite to select all the time as possible, and delay the Insert, I don't care the time that took insert something. These is my needs with SQLite. Is something Interesting on my idea? If there is one I will share my idea. If you're trying to save your inserts until your app has some idle time, the best technique I can come up with is to cache those inserts in your application. When your activity monitoring thread detects that there is no other database activity it can fire off a process to perform the inserts. That keeps your app very responsive to user queries. If you find that you need a higher degree of concurrency you might consider PostgreSQL. But you'll probably be okay with SQLite as long as your app can find the time to run the inserts often enough. Clay -- http://www.lazarusid.com/notes/ Lazarus Notes Articles and Commentary on Web Development
[sqlite] Insert delay!
I was thinking a lot in the next month in how can I do the delay insert and I found something for do that, is basic because I don't have a lot of knowledge, I'm just start the University. OK, I need with SQLite to select all the time as possible, and delay the Insert, I don't care the time that took insert something. These is my needs with SQLite. Is something Interesting on my idea? If there is one I will share my idea.