Red Gate forums :: View topic - SQL Search is indexing your database - Every time I search
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Search 1
SQL Search 1 forum

SQL Search is indexing your database - Every time I search

Search in SQL Search 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
a_j_k



Joined: 21 Jan 2011
Posts: 2

PostPosted: Fri Jan 21, 2011 3:46 pm    Post subject: SQL Search is indexing your database - Every time I search Reply with quote

Something has changed recently.

Previously SQL Search worked as expected, now whenever I do a search I get the "SQL Search is indexing your database. This will only happen once." message and it takes a very long time (many minutes) for SQL Search to index the database. Once it finishes I'm able to search.

The next time I try to search the same database, I get the same message and it goes through the indexing process again.

I'm running version 1.0.0.321 in Microsoft SQL Server Management Studio version 10.0.4000.0 running on 64-bit Windows 7.

Does anyone have any suggestions about why this would be happening or how to fix it?

Thanks.
Andy.
Back to top
View user's profile Send private message
emoreau



Joined: 23 May 2006
Posts: 38

PostPosted: Tue Jan 25, 2011 2:03 pm    Post subject: Reply with quote

same thing here! any fixes coming soon?
Back to top
View user's profile Send private message
tanya



Joined: 30 Apr 2007
Posts: 253

PostPosted: Tue Jan 25, 2011 3:51 pm    Post subject: Reply with quote

Oops that is weird. I can email you both a new build so that you can check if that fixes your issue?

Thanks and apologies for any inconvenience this has caused.

Regards,
Tanya
Back to top
View user's profile Send private message
nhustak



Joined: 09 May 2006
Posts: 34

PostPosted: Wed Jan 26, 2011 3:39 pm    Post subject: Reply with quote

I've crashed four times today (sql search sent the log) - I wonder if this is related. Worst it's been - had just happened once a day or so.

The funny thing is that I haven't used it all today, so it's gotta be a background task tanking.

I LOVE sql search but for some reason this latest patch is unstable on my
system.

I work with a lot of systems over a VPN that isn't the best in the world. I would really like it to NEVER index them unless I ask it too.

Even better - an option to simply make indexing manual. I don't use it that often (but boy am I glad I have it when I need it) I would be fine with waiting for an indexing to get done before I search.
Back to top
View user's profile Send private message
tanya



Joined: 30 Apr 2007
Posts: 253

PostPosted: Wed Jan 26, 2011 3:44 pm    Post subject: Reply with quote

That is not good... can you confirm the build number of your SQL Search please?
You can find this by clicking on Help - About.

Thanks,
Tanya
Project Manager
Red Gate Software Ltd
Back to top
View user's profile Send private message
a_j_k



Joined: 21 Jan 2011
Posts: 2

PostPosted: Wed Jan 26, 2011 4:08 pm    Post subject: Reply with quote

I have not had the test version crash for me, but I've not used it that much. It still indexes the DB every time I access the same database. I uninstalled the old version and installed the new one.
Back to top
View user's profile Send private message
scottdavidnelson



Joined: 28 Jan 2011
Posts: 2

PostPosted: Fri Mar 11, 2011 7:04 pm    Post subject: Reply with quote

I also am experiencing this same issue, constant reindexing.

Has there been any thought given to changing the design of this tool so that it doesn't build an index at all, but rather just querying the system tables every time?

Idera SQL Search works this way and it's very fast, no indexing required.
Back to top
View user's profile Send private message
tobiasly



Joined: 08 Apr 2011
Posts: 1

PostPosted: Fri Apr 08, 2011 2:05 pm    Post subject: Reply with quote

This is happening to me with version 1.0.0.340. I'm not even sure how I got this version since it's later than the version on the website (it was installed on my PC at work before I got here). Can you please give an update on this and whether I'm using the correct version?

BTW I also have a license for RedGate Developer Bundle if that matters.
Back to top
View user's profile Send private message
spivey24



Joined: 17 Oct 2006
Posts: 18

PostPosted: Mon Apr 11, 2011 9:07 pm    Post subject: Reply with quote

I have a search stored procedure that scans all of syscomments for text like some param. It takes 4 seconds on a slow server with 1400 stored procedures. It would be nice if SQL Search degraded to a brute force scan if no index existed yet.

If I have a quick search I always use the search sproc instead because I will get results faster, but I really like being able to click on the object and have it highlight in the Object Explorer with SQL Search.
Back to top
View user's profile Send private message
joe12pack



Joined: 21 Nov 2013
Posts: 1
Location: United States

PostPosted: Thu Nov 21, 2013 3:11 am    Post subject: Did Hellen Keller design SQL Search? Reply with quote

I can't tell if the thing is working or not. There's no search button. I just type in what I am looking for and it says it's indexing but it will just index only one time- even though it says that every time I search. Even if the searches are 10 minutes apart.

Sometimes it works. Sometimes it takes forever. It's faster for me to just search though the stored procs for what I am looking for one by one.

Someone needs to seriously redesign this thing. It's a POS.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group