Path: csiph.com!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!eternal-september.org!feeder.eternal-september.org!mx02.eternal-september.org!.POSTED!not-for-mail From: Matthew Carter Newsgroups: comp.lang.php Subject: Re: slightly OT - forms in database Date: Sun, 08 Feb 2015 21:39:36 -0500 Organization: Ahungry (http://ahungry.com) Lines: 22 Message-ID: <878ug7byfr.fsf@ahungry.com> References: <7a98b02a-f124-4fda-ad08-76852a689af3@googlegroups.com> <87d25kb0g6.fsf@ahungry.com> Mime-Version: 1.0 Content-Type: text/plain Injection-Info: mx02.eternal-september.org; posting-host="7c986cd4736462de309a749b207746fe"; logging-data="19969"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX19SKIQFP+j/4rm2dCwxuL0G" User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/24.4 (gnu/linux) Cancel-Lock: sha1:Zaaza+mZhmsSVzOXEbKgHXn/ZeY= sha1:SQDZ0JpbScTgTjeNKA02ydJ1/Nk= Xref: csiph.com comp.lang.php:14925 Denis McMahon writes: > On Sun, 08 Feb 2015 15:41:29 -0500, Matthew Carter wrote: > >> It would add some technical debt for sure, but running queries against >> flat text fields (like TEXT type in MySQL) is still ridiculously fast >> even on a few hundred thousand rows for LIKE type queries. > > What happens when your database starts reaching tens of billions of rows. > > There's a reason we normalise databases. Think thats going to happen here? If it was a project where they anticipated that scale, I don't think they'd have someone asking how to do it here. Reality is that it's probably only going to have a few thousand forms filled out max, if that, but what do I know. -- Matthew Carter (m@ahungry.com) http://ahungry.com