Path: csiph.com!eternal-september.org!feeder.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail From: Cecil Westerhof Newsgroups: comp.lang.java.programmer Subject: Re: Where to put the return Date: Sat, 19 Aug 2017 14:10:32 +0200 Organization: Decebal Computing Lines: 35 Message-ID: <87378niwqv.fsf@munus.decebal.nl> References: <87zib6zeup.fsf@munus.decebal.nl> <87y3qlnyvj.fsf@munus.decebal.nl> <87bmnbj09u.fsf@munus.decebal.nl> <877exzixum.fsf@munus.decebal.nl> Mime-Version: 1.0 Content-Type: text/plain Injection-Info: mx02.eternal-september.org; posting-host="3820b20d39a2e7728f71dbc5da182e9b"; logging-data="21301"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX19dNeQzazUJ9Zbaz4mBDIRVz0EkiND9SO8=" User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/24.5 (gnu/linux) X-Homepage: http://www.decebal.nl/ Cancel-Lock: sha1:1Ic01P/KWM8F1QyYd1UI5BG+Amw= sha1:6TLGV5FRN4zf16PA+VEyB/iKVCU= Xref: csiph.com comp.lang.java.programmer:37283 Cecil Westerhof writes: > Cecil Westerhof writes: > >>>> The SQL used: >>>> SELECT used >>>> FROM usedProverbs >>>> LIMIT 1 >>>> >>>> I defined usedProverbs as a sorted view (on proverbs), that is why >>>> there is no SORT BY. >>> >>> Sorted view is another thing I would not do. I am not sure that is even >>> a supported features across most databases. It does have issues - >>> technical and conceptual. >> >> In this case it is on a SQLite3 database which does have it and I >> think it very unlikely to change. But you are right: when I want the >> code to be portable I should not use this, or add a comment to the >> code. > > The double sort makes a HUGE difference. So big that it is even not > reasonable. My version (when executed in the DBBrowser) almost always > takes 0 ms and sometimes 1. When I add the ORDER BY it becomes between > 13 and 16 ms. I would expect only sometimes 2 ms. I made an unsorted view and if I use that the performance is like it was. The sort was only added because I got a sorted list when looking with DBBrowser at the data. But that is only one click and is not something I do a lot, so I will remove the sorts from my views. -- Cecil Westerhof Senior Software Engineer LinkedIn: http://www.linkedin.com/in/cecilwesterhof