Re: [PHP] Re: find (matching) person in other table

On 5/30/07, Afan Pasalic <afan@xxxxxxxx> wrote:
email has to match "in total". sales@xxxxxxxxxxxx and info@xxxxxxxxxxxx
are NOT the same in my case.

thanks jared,

If you can match a person by their email, why not just SELECT by email only
(and return the persons information)?

Consider, as well, that each time you're calling a database, you're slowing
down the response of the page. So, while making a bunch of small calls might
not seem like that much, consider:

||||||| x |||||||
||||||| a |||||||
||||||| b |||||||

Versus

||||||| x, a, b |||||||

The letters represent the request/response data (what you're giving to get,
then get back), and the pipes (|) are the overhead to process, send, receive
(on DB), process (on DB), send (on DB), receive, process, return to code.

The overhead and latency used to complete one request makes it a quicker,
less "heavy" operation. If you did the first a couple hundred or thousand
times, I would bet your page would drag to a halt while it loads...

--
Jared Farrish
Intermediate Web Developer
Denton, Tx

Abraham Maslow: "If the only tool you have is a hammer, you tend to see
every problem as a nail." $$

Relevant Pages

  • Re: [PHP] Re: find (matching) person in other table
    ... Jared Farrish wrote: ... 'cause some members can be added to database by administrator and maybe ... > The letters represent the request/response data (what you're giving to ... > then get back), and the pipes are the overhead to process, send, ...
    (php.general)
  • Re: [PHP] Re: find (matching) person in other table
    ... Jared Farrish wrote: ... 'cause some members can be added to database by administrator and maybe ... > The letters represent the request/response data (what you're giving to ... > then get back), and the pipes are the overhead to process, send, ...
    (php.general)
  • Re: Wanted:MAIL.MAI structure definition
    ... a relational database is more flexible in the retrival of data. ... Perhaps this impact has been softened as hardware has gotten faster, but, overhead is overhead, and if you weren't using the advances in hardware for overhead, those designs that have less overhead would also gain from the faster hardware. ... RFC822 header because your XML parser wouldn't be able to understand new ...
    (comp.os.vms)
  • Re: Newbie - general question about ADO.NET
    ... Sure, it carries some overhead, but worrying about the minor amount ... If a database is localy on PC - ... ADO.NET is connectionless, but I don't care about connection, ... >>> because the database is located on PocketPC. ...
    (microsoft.public.pocketpc.developer)
  • Re: Datatransfer objects
    ... are designed like the database tables. ... But I don't immediately store the data into the database, ... "Without any overhead" is a pipe dream. ... What overhead to JPA solutions have, and why do you seek to avoid it? ...
    (comp.lang.java.databases)