When you use the wildcard two queries happen. One to find the name of the
fields and another to actually do the query. If you are returning all 50
fields then you are using up server resources by storing more query results
in memory. It is best to be a specific as possible for each query. If yo
I asked a similar question before and I was told that it is quicker to write
out all the field names instead of using the *.
-Original Message-
From: Michel Gagnon [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 12, 2000 12:33 PM
To: [EMAIL PROTECTED]
Subject: To wildcard or not to wild
Basically think of it this way, the data passed back from the database is
going to contain one record row for each one returned, which will either
contain 4 fields or 50 fields...if you return 100 rows that would be:
4 * 100 = 400
50 * 100 = 5000
I think it is clear which would be faster and more
3 matches
Mail list logo
