CanMan2004 Posted January 15, 2007 Share Posted January 15, 2007 Hi allI have a sql table which has over 350,000 records in it, I did build a front end which runs a selection of querys.The problem I have is that I think the table is too large as it's taking ages to perform a query on it and ends up timing out.Can anyone help?ThanksEd Quote Link to comment Share on other sites More sharing options...
tresloukadu Posted January 15, 2007 Share Posted January 15, 2007 hey man :) have u ever tried do an Index ??? Quote Link to comment Share on other sites More sharing options...
ToonMariner Posted January 15, 2007 Share Posted January 15, 2007 do you have text fields in your table?They slow things down a lot. Maybe consider placing all your text entries in a table of their own and just storing the unique id. Quote Link to comment Share on other sites More sharing options...
CanMan2004 Posted January 15, 2007 Author Share Posted January 15, 2007 How do I do an index? Not something ive ever done.The table holds text and digitsThanks Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.