I have a question on philosophy or rationale of MySQL usage with PHP.
I have setup a script to enter event dates from a user submitted form. This forms allows for repeating dates. So i have decided to make my script evaluate all the possible dates and enter them into a database.
Now, my question arises when i created a looping function to cycle through the possible dates.
Should i have the function add each date one at a time into the database providing numerous connections to the database, or should i store them as an array and submit them to the database once the dates have been calculated??
i.e. Would it be better to have a LOT of SMALL connections to MySQL
or
would it be better to have a FEW LARGE connection to MySQL
in terms of speed, server load, and basic principles of databasing??
any help appreciated,
cheers,
zoo
Database Querying Philosopy
Moderator: General Moderators