hi all I am developing a kind of social networking site, and countered a problem with feeds. basically what i did is have a feed table and each time when a member post an item, if he has 100 friends in his network, then 100 entries of feeds will be inserted into the feed table. this works fine in testing locally. however, after putting my site online, sometimes some feeds are not inserted. I am wondering probably it is because insertion of a lot of entries would cause the database to miss some hits. not too sure whether this is the reason. I am using php + mysql anyone helps me find the solution to this? thanks a billion
You need to create an error logging system,or look in your mysql logs to see if there is currently a problem. Generally the only thing that would cause an error, would be something related to the syntax of the inserts, or incompatibilities in inserting data into a particular field (Ex: inserting a letter onto an int column).