Hi,
I'm programming a web based grammar and spell checker in VB net. It is meant for small to very large texts of up to a few hundred pages.
The user can type or copy and paste text from any document type into the editor to have it checked.
The application must connect to a database to retrieve various information for each word checked. Depending on the language checked the table fields and amount of tables to check vary.For each checked word the application stores some information in dictionaries
in order to avoid that the same word occuring several time in a text is only checked once for each occurence. But still each time it has to access the database it has to access different tables depending on which type of word it is and this can execute up
to 8 sql queries.
Now the problem is that the longer the text inserted in the WYSIWYG editor the longer the checking takes after sending off the data which will eventually result in a timeout.
Go to the complete details ...