All,
I have been writing my applications using PHP/MySQL for about a year and
a half now. During this time and up to now, there hasn't been anything
wrong with my apps; however, I need to know if what I am doing is the
best route for optimal performance.
So I ask these questions:
1. How many queries can MySQL handle?
For example, one of my functions does this:
While (I am selecting some data)
{
while (use one of the results as an element to query a
different table)
{
echo the results formatted in html
}
}
I'm sure that I could be using a join, but this is an example.
2. I am under the impression that a char is 'a character', but I
have read and think I have seen it used with more than one character.
For example, char (5). If this is correct, how many values can char
hold?
3. Is it true that varchar appends spaces to the value if it's not
all set? For example, if a varchar is set to 255 and my value is really
only 245, then 10 whitespaces will be appended to the original value.
-Jonathan
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
