Profiler says 64 Queries being run. is that too high? should i be worried?

[eluser]ntheorist[/eluser]
[quote author="Latavish" date="1224803341"]yikes!! joins are scary. lol[/quote]

heh, they do seem complicated.. i avoided doing them for a while, until i started running into the same kind of performance issues. It's pretty abstract and does require more complex queries, but once you learn them and apply it to what you're doing it will make sense. It will also boost performance.. in some cases you can compress several hundred queries into one and get the same data, so its worth it to learn.

Some advice

1. get acquainted with normalization : Read Here

dont worry if the wording is confusing. its basically all about separating data objects into separate tables and relating them based on their id's

2. learn the syntax : MySql Joins

3. to start, stick with left joins, they are the most common and easy to work with

4. either prepend each field in a table with a prefix, or refer to fields by 'tablename.fieldname', column ambiguity is a common problem when using joins

5. when you run into new errors, google it (in quotes). 99.9% of the time someone has had the same exact error you're running into and you'll find the solution quickly this way.

good luck,

CC