Latley we're having some strange behavior in some large databases. Sometimes the queries just takes a long time to run. They've run fine earlier. Is there a limit in rows/data that one should stribe to not exceed? It's on a fast machine with almost 12Gb free space. One table e.g has 1126320 rows. The database in question takes up 1845 Mb after a shrink logs. I'm not sure if trunkating the large tables or remove tables not beeing used would be best. Greatful for any input.
mwedberg
0
Newbie Poster
Recommended Answers
Jump to PostYes indexes are your first concern. !. do you have any, then 2. are you indexing the right columns (typically the ones involved in JOINS)
Next are your statements optimized ? (could write a book on this he he) but take the particular query you mention try to ensure …
All 3 Replies
Reply to this topic
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.