Queries Question

[eluser]ericsodt[/eluser]
[quote author="RS71" date="1233017760"][quote author="ericsodt" date="1233017147"][quote author="RS71" date="1233015553"]Oh forgot to ask this:

I'm only 3/5 of the way into the completing the form code and its currently consuming:

MEMORY USAGE
2,266,544 bytes

I have no idea if this is too much or too little. Is it affected by the queries?[/quote]

You can do those queries with join statements, however you're going to have to parse the data to populate your user object, which would make little sense.

I don't know if you have worked with an ORM tool before or not, but I work with Hibernate and Hibernate does exactly what you're doing. One way to speed it up might be to add some index's on the fields that you're querying the most.

Goodluck[/quote]

Hello

Would it be wise to go with the JOIN approach performance wise? (I plan on having lots, but lots of page accesses a day) I don't think I've done queries before that use JOIN when dealing with single row results and multiple results from multiple tables. What would the structure of the results look like?

I don't believe I've worked with ORM tools before. Could you please elaborate?

Thank your for your assistance ericsodt [/quote]

Check out:
1. http://www.doctrine-project.org/
2. http://www.hibernate.org/ (reference this, since its for java not PHP)
3. http://www.developertutorials.com/blog/p...n-php-331/