David92595
Registered User.
- Local time
- Today, 07:30
- Joined
- Jun 28, 2011
- Messages
- 44
Hello,
Basics: I'm running SQL Server 2008 R2 back end with access 2007 front end.
I have a Full Text Index set up on our main table which is have set up to re-index every morning at 3am, or at least that's what I'm reading in the Properties of the table. However, day after day our searches are still very slow. The table is relatively small only 14,000 records or so. So I know this should not be a big deal for SQL.
Any suggestions for what I should be looking into to speed up searching of indexed fields?
I am currently reorganizing the table on a nightly basis, a few hours before the re-index takes place. Could this have anything to do with it???
Thank you in advance, and please let me know if you need more information.
David92595
Basics: I'm running SQL Server 2008 R2 back end with access 2007 front end.
I have a Full Text Index set up on our main table which is have set up to re-index every morning at 3am, or at least that's what I'm reading in the Properties of the table. However, day after day our searches are still very slow. The table is relatively small only 14,000 records or so. So I know this should not be a big deal for SQL.
Any suggestions for what I should be looking into to speed up searching of indexed fields?
I am currently reorganizing the table on a nightly basis, a few hours before the re-index takes place. Could this have anything to do with it???
Thank you in advance, and please let me know if you need more information.
David92595