Posted 17 February 2006 - 12:24 AM
What is the best way to eliminate duplicate entries from occuring?
My second question is regarding the time it takes to update the database. It used to take about 10 seconds to update the data from my php form. (Its only text) It now takes about 30 to 45 sec. Could there be a issue with the database now that it has gotten a little bigger that is causing access to slow? It has about 175 records, all of which are text only. (about 12 fields per record)
When I display the contents of the database on a webpage it updates in about 5 to 7 seconds, so it seems the slowdown occurs only when I write to the database. I recall that Microsoft Access had a database optimize function that reduced the size of the file. Perhaps I have to do something like that with the mysql database to speed it up?
Posted 17 February 2006 - 04:31 AM
Posted 17 February 2006 - 08:35 AM
WRT duplicate records, you can easily disable the submit button onsubmit, check the sessionUID / cookie to make sure they haven't submitted, etc.. It's non-trivial to do this properly on the DB end.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users