by John Gardbe » Fri, 10 Jan 1997 04:00:00
I am dealing with files with upto 1,000,000 records.
The programs that i have written work well on files upto 100k records.
I have used/tried
The Data Control, DAO and DAO using ODBC.. any help would be
appreciated...
I am considering the ODBC API and or CodeBase.
John Gardberg
by Erick Smit » Sat, 11 Jan 1997 04:00:00
If you have set up your database and indexes properly, the DAO should work
very well...
Quote:> I am dealing with files with upto 1,000,000 records.
> The programs that i have written work well on files upto 100k records.
> I have used/tried
> The Data Control, DAO and DAO using ODBC.. any help would be
> appreciated...
> I am considering the ODBC API and or CodeBase.
> John Gardberg
1. ADO Connection Speed Connection
Hello Everyone,
I need to write store procedure that will run about 500 hundreds time per
second.
NT 4.0 Server, Option Pack 4.0 IIS 4.0, ADO 2.1,SQL 7.0
In first I try to write this code:
With GlobalCommand
.ActiveConnection = clsdb.Db
.CommandType = adCmdStoredProc
.CommandText = "sp_add_Location"
.Execute
End With
i ran this 1000 time and it took about 45 second.
mvardb.Execute "sp_add_location '054341432','Message',12.3,10.2,'" & Now &
"',1"
on the other hand I ran this code 1000 times and it took between 6 to 8
second.
When I am running from Query Analyzer in loop(sp_add_location_1000 ) the
loop is in the store procedure it took 2 second.
Can I optimize the ADO more than the second choice.
2. continued look-up button problem in visual basic .net
3. windows + postgresql + java? Is it possible?
4. Speed, speed, speed, and Sybase disk limitations
5. REMINDER: OOPSLA '99 WS on Java and Databases
8. Speed, Speed, Speed, and a ramdisk too
9. speeding up loading lists from dbase IV file
10. Can I speed up my dBase IV application?
12. Execution Speed of Compiled dBASE program