Stored procedure use Sqlite : Android

Question

My query is can we write stored procedure in sqlite so that it can be accessed from my android java class?

I have refered Creating stored procedure and SQLite?

And if no then is there any other way to perform this kind of activity in android??

Community · Accepted Answer · 2017-05-23 12:06:34Z

5

No you cant have a stored procedure on SQLite. It is not a multi user database server like MySQL or SQL-Server. Just create a normal query and execute it. See this link for more information How to run query in SQLite database in android?.

Remember the speed benefit of a stored procedure is that it does not have to recompile and that its query plan can be generated before execution. This is great in a multi user environment but not in a single user environment like SQLite.

edited May 23, 2017 at 12:06

CommunityBot

11 silver badge

answered Aug 26, 2013 at 6:40

Namphibian

12.3k8 gold badges50 silver badges77 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Stored procedure use Sqlite : Android

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related