Re: slightly OT - forms in database

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 <m@ahungry.com>
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> (permalink)
References	<7a98b02a-f124-4fda-ad08-76852a689af3@googlegroups.com> <mb7q9a$ckl$1@dont-email.me> <87d25kb0g6.fsf@ahungry.com> <mb8lsk$ce8$5@dont-email.me>
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

Show key headers only | View raw

Denis McMahon <denismfmcmahon@gmail.com> 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

Thread

slightly OT - forms in database tim@timothyarnold.co.uk - 2015-02-08 01:47 -0800
  Re: slightly OT - forms in database "J.O. Aho" <user@example.net> - 2015-02-08 11:17 +0100
  Re: slightly OT - forms in database Denis McMahon <denismfmcmahon@gmail.com> - 2015-02-08 13:33 +0000
  Re: slightly OT - forms in database Jerry Stuckle <jstucklex@attglobal.net> - 2015-02-08 09:02 -0500
    Re: slightly OT - forms in database Matthew Carter <m@ahungry.com> - 2015-02-08 15:41 -0500
      Re: slightly OT - forms in database Jerry Stuckle <jstucklex@attglobal.net> - 2015-02-08 16:09 -0500
      Re: slightly OT - forms in database Denis McMahon <denismfmcmahon@gmail.com> - 2015-02-08 21:53 +0000
        Re: slightly OT - forms in database Matthew Carter <m@ahungry.com> - 2015-02-08 21:39 -0500
      Re: slightly OT - forms in database Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2015-02-09 00:52 +0100

csiph-web