limit number of mysql rows that can be written into a db

[juve11]

hello, i have a vb application that writes into mysql (some kind of autocomplete).

problem is that it writes too many rows and the app at a moment starts to run slowly.so an option that i thaught about is that to limit number of rows that can be written in mysql, i just dont know if that is possible?

thank you!

[ronverdonk]

Why would you lay responsibility for the number of rows inserted with MySQL? Since your VB program does the writing, put your limit in your VB.

Ronald

[juve11]

i choose to put a select command with group by id desc limit 50 and i will wait to see how it works

thank you

[ronverdonk]

i choose to put a select command with group by id desc limit 50 and i will wait to see how it works

thank you

Of course you can LIMIT a select result set. But your question was how you could limit the number of writes into the database!

Ronald