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 Link to comment https://forums.phpfreaks.com/topic/34241-massive-table-slow-queries/ 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 ??? Link to comment https://forums.phpfreaks.com/topic/34241-massive-table-slow-queries/#findComment-161054 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. Link to comment https://forums.phpfreaks.com/topic/34241-massive-table-slow-queries/#findComment-161055 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 Link to comment https://forums.phpfreaks.com/topic/34241-massive-table-slow-queries/#findComment-161065 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.