General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
It only takes a second or two now. I can't imagine running it twice would make it noticably faster. :)
Thanks,
Michelle
>You should test for speed. Sometimes separating a SQL - SELECT command into several commands is much faster. For instance, I had a 9-table SELECT, which took me 50 seconds over the network. I separated in in several commands, joining first two tables, then a third, then a fourth, etc., and execution time dropped from 50 seconds to 2 seconds.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only