Anonymous
quote:
Originally posted by pdxyyz
quote:
Originally posted by UncleVic
quote:
Originally posted by pdxyyz
quote:
Originally posted by tjr
I get an SQL error when I try to search for posts by a member name.Sorry if this is the wrong place to post this question.
Line 1: Incorrect syntax near ‘)’.
/Forums/search.asp, line 447
This error indicates a problem with the SQL query itself and defragging won’t resolve the issue. Has anyone changed the query related to the search lately? If not this could also be an issue with some bad data.
What ever it is the query is violating the rules of SQL.
Without seeing the actual query being run that’s as far as I can get with this.
I think it has to do with the seek times on the drive.. Could be wrong here, but thats why I suggested Defrag (to reorganize the databases)… Was just one mans opinion here…
An SQL syntax error is returned when the SQL query is parsed by the database engine. This is before any attempt is made to retreive any data from the database, so this error is not seek time related.
Now the slow file loading if being seen by everyone would be an issue with seek time.
If the database itself is fragmented, a disk defrag will not help that much since defragging the file the database uses does not defrag the data held in that file. That requires a database compress.
And while we’re in a mood to perform preventive maintenance, lets do some table re-indexing as well.
Guess who was a DBA in a former life.
[:p]
You’re Hired… Free Fries on break there… [8D]