Is there a limit to sampdb(SQLite) rows ?
#2

A thousand rows is nothing. Even SQLite should easily handle a couple hundred thousand rows. But what you're doing is just a terrible way to do it. Send one query with Limit 1000 instead of 1000 separate queries. Then use a while loop to process the result set (because there may be less than 1000 rows).
Reply


Messages In This Thread
Is there a limit to sampdb(SQLite) rows ? - by Ahmad45123 - 23.04.2015, 20:10
Re: Is there a limit to sampdb(SQLite) rows ? - by Vince - 23.04.2015, 20:16
Re: Is there a limit to sampdb(SQLite) rows ? - by Sergei - 23.04.2015, 20:19
Re: Is there a limit to sampdb(SQLite) rows ? - by Ahmad45123 - 23.04.2015, 20:19
Re: Is there a limit to sampdb(SQLite) rows ? - by PowerPC603 - 23.04.2015, 21:05

Forum Jump:


Users browsing this thread: 1 Guest(s)