Click here to Skip to main content
12,394,769 members (69,475 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: C# MySQL
Hi Guys,
I need to do re-indexing in MYsql database using C# code and SQL query.
Can anyone help me how I can do this.

Thanks
Posted 16-Apr-10 8:45am
Updated 16-Apr-10 8:46am
v2
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

Doesn't MySQL automagically reindex when you add rows to a table? Why do you want to manually reindex? Are you changing the index key?
  Permalink  
v3
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

Does it reindex? I was not knowing it. Are you sure?
  Permalink  
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 3

I want to reindex time to time manually to make application faster.
  Permalink  
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 4

just drop the index and recreate the indesx from c#, whats the problem in that?
  Permalink  
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 5

Thanks for the suggestions guys
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160721.1 | Last Updated 21 Apr 2010
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100