i have msde installed and running on my local pc. i have 2 db's which both reside on my loacl pc as well. both db's are the same. i have an app that access and retrives data for a db. when i run the app connected to db1 it takes abount 3 seconds to retrive and dispaly my data. when i connect to db2 with the same app, it takes about 35 seconds to retrive the same data. is there some sort of setting on db1 that needs to be set for db2 or can it be some sort of worm on db2 which has not effected db1. if you have any ideas please let me know.
sorry i ran the command from the wrong location. i ran it from the proper p;ace and it update my indexes with out error and now my app runs perfectly. thak you very much. one question how often should i run this command? also is there any negative effects to running this comand?