Đang Thực Hiện

166672 Re-Write a one-page script

The attached page currently work fine, but it has the problem of failing to insert the record sometimes especially when more than 50 people access the page at the same time..

What the attach script does is to count the database table using a loop. This is not very effective since most times it fails to insert. The two database tables currently have more than 80,000 records and counting individual record to determine where to insert the next record may be the reason why it fails sometimes to insert.

Someone suggested using a GetRow() function to determine when to insert the next record.

Please consider the best approach and ensure that it is one record that has to be inserted at a time so that it will never fail to insert.


Kĩ năng: Bất kì công việc gì, ASP, MySQL

Xem nhiều hơn: problem approach, approach problem, a one, write one page, people counting, mysql inserted, loop table, attach database using, mysql insert loop, count people using, people count using, using access counting, asp script insert, counting people, count mysql, mysql attach, script write database, write database script, attached page, script insert mysql, mysql table count, count script page time, function write, count script, mysql loop tables

Về Bên Thuê:
( 1 Nhận xét ) Dublin, Ireland

ID dự án: #1912865