Codejock Developer Community : Need Example Of Database Usage http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 13 May 2026 01:45:42 +0000 Sat, 31 May 2008 15:02:48 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=10243 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[Need Example Of Database Usage : Aaron wrote:Hi, I did test...]]> http://forum.codejock.com/forum_posts.asp?TID=10243&PID=36070&title=need-example-of-database-usage#36070 Author: Aaron
Subject: 10243
Posted: 31 May 2008 at 3:02pm

Originally posted by Aaron Aaron wrote:

Hi,
 
I did test the 2 options and the option Baldur gave us was faster, good job
 
I did ten runs for each option (slow machine 800Mhz and about 40000 items) but you can see the difference. I think Nick will have to change the sample again
 
Hi,
 
The test I did was with the sample @nvierros provided. Someone else asked a sample for the same thing and I made one with two possible options (DAO and ADODB) and it seems that DAO is faster.
 
Loading about 200.000 records:
  1. ADODB - 22,04 sec. 
  2. DAO - 15,75 sec.
For anyone who is still interested see post:
http://forum.codejock.com/forum_posts.asp?TID=10814
 
 
]]> Sat, 31 May 2008 15:02:48 +0000 http://forum.codejock.com/forum_posts.asp?TID=10243&PID=36070&title=need-example-of-database-usage#36070 <![CDATA[Need Example Of Database Usage : Hi, That is correct ]]> http://forum.codejock.com/forum_posts.asp?TID=10243&PID=34208&title=need-example-of-database-usage#34208 Author: Aaron
Subject: 10243
Posted: 24 April 2008 at 3:11pm

Hi,
 
That is correct
]]> Thu, 24 Apr 2008 15:11:52 +0000 http://forum.codejock.com/forum_posts.asp?TID=10243&PID=34208&title=need-example-of-database-usage#34208 <![CDATA[Need Example Of Database Usage : Aaron wrote:Hi, With Xt...]]> http://forum.codejock.com/forum_posts.asp?TID=10243&PID=34197&title=need-example-of-database-usage#34197 Author: braian87b
Subject: 10243
Posted: 24 April 2008 at 11:41am

Originally posted by Aaron Aaron wrote:

Hi,
 
With XtremeRecord.AddItem(rs.Collect(Index))
    If IsNull(.Value) Then
         .Value = Empty
    End If
End With
Collect is returning the value Field(index) in the recordset
 
 
Yes, but i think that  XtremeRecord.AddItem is who returning the Item object and the .Value Property corresponds to the Item,
 
Is'n it? or Im Wrong?
 
Because youre passing rs.Collect to the AddItem Method as an argument.
dont you?
 
]]> Thu, 24 Apr 2008 11:41:50 +0000 http://forum.codejock.com/forum_posts.asp?TID=10243&PID=34197&title=need-example-of-database-usage#34197 <![CDATA[Need Example Of Database Usage : Aaron wrote:Hi, With...]]> http://forum.codejock.com/forum_posts.asp?TID=10243&PID=34178&title=need-example-of-database-usage#34178 Author: younicke
Subject: 10243
Posted: 23 April 2008 at 1:49pm

Originally posted by Aaron Aaron wrote:

Hi,
 
With XtremeRecord.AddItem(rs.Collect(Index))
    If IsNull(.Value) Then
         .Value = Empty
    End If
End With
Collect is returning the value Field(index) in the recordset
 


sorry my bad. i was blind at that moment.. i didnt see it.. hehehe ]]> Wed, 23 Apr 2008 13:49:50 +0000 http://forum.codejock.com/forum_posts.asp?TID=10243&PID=34178&title=need-example-of-database-usage#34178 <![CDATA[Need Example Of Database Usage : I have Version 12.2 and if an...]]> http://forum.codejock.com/forum_posts.asp?TID=10243&PID=34177&title=need-example-of-database-usage#34177 Author: Baldur
Subject: 10243
Posted: 23 April 2008 at 1:41pm

I have Version 12.2 and if an item contains NULL instead of Empty, the hole row will be ignored.
Thats, why i change it to empty.
]]> Wed, 23 Apr 2008 13:41:20 +0000 http://forum.codejock.com/forum_posts.asp?TID=10243&PID=34177&title=need-example-of-database-usage#34177 <![CDATA[Need Example Of Database Usage : Lodep59 wrote:Dear Aaron, I...]]> http://forum.codejock.com/forum_posts.asp?TID=10243&PID=34159&title=need-example-of-database-usage#34159 Author: Aaron
Subject: 10243
Posted: 23 April 2008 at 7:33am

Originally posted by Lodep59 Lodep59 wrote:

Dear Aaron,
 
I was talking about the use of adocommand not rs.collect.
You're right, the collect method is faster because it doesn't need a reference to the field object. Why this method is hidden is an other subject...
 
Sorry to have disturbed you.
 
You can always disturb me  
But you were right about that. Keep the code as simple as can be. Keep "bugging" me and the other members
]]> Wed, 23 Apr 2008 07:33:43 +0000 http://forum.codejock.com/forum_posts.asp?TID=10243&PID=34159&title=need-example-of-database-usage#34159 <![CDATA[Need Example Of Database Usage : Hi, With XtremeRecord.AddItem(rs.Collect(Index))...]]> http://forum.codejock.com/forum_posts.asp?TID=10243&PID=34157&title=need-example-of-database-usage#34157 Author: Aaron
Subject: 10243
Posted: 23 April 2008 at 7:08am

Hi,
 
With XtremeRecord.AddItem(rs.Collect(Index))
    If IsNull(.Value) Then
         .Value = Empty
    End If
End With
Collect is returning the value Field(index) in the recordset
 
]]> Wed, 23 Apr 2008 07:08:22 +0000 http://forum.codejock.com/forum_posts.asp?TID=10243&PID=34157&title=need-example-of-database-usage#34157 <![CDATA[Need Example Of Database Usage : Aaron wrote: Baldur solution:...]]> http://forum.codejock.com/forum_posts.asp?TID=10243&PID=34151&title=need-example-of-database-usage#34151 Author: younicke
Subject: 10243
Posted: 23 April 2008 at 6:10am

Originally posted by Aaron Aaron wrote:

 
Baldur solution: (seems about 2 seconds faster, look my post above)
 
For Index = 0 To rs.Fields.Count - 1
    With XtremeRecord.AddItem(rs.Collect(Index))
         If IsNull(.Value) Then
             .Value = Empty
         End If
    End With
Next


hi aaron,

what object is being referenced in the ".value"?
i didnt see any WITH  statement.

thanks
]]> Wed, 23 Apr 2008 06:10:25 +0000 http://forum.codejock.com/forum_posts.asp?TID=10243&PID=34151&title=need-example-of-database-usage#34151 <![CDATA[Need Example Of Database Usage : Dear Aaron, I was talking about...]]> http://forum.codejock.com/forum_posts.asp?TID=10243&PID=34146&title=need-example-of-database-usage#34146 Author: Lodep59
Subject: 10243
Posted: 23 April 2008 at 5:10am

Dear Aaron,
 
I was talking about the use of adocommand not rs.collect.
You're right, the collect method is faster because it doesn't need a reference to the field object. Why this method is hidden is an other subject...
 
Sorry to have disturbed you.
]]> Wed, 23 Apr 2008 05:10:30 +0000 http://forum.codejock.com/forum_posts.asp?TID=10243&PID=34146&title=need-example-of-database-usage#34146 <![CDATA[Need Example Of Database Usage : Dear @Lodep59 The how is possible...]]> http://forum.codejock.com/forum_posts.asp?TID=10243&PID=34095&title=need-example-of-database-usage#34095 Author: Aaron
Subject: 10243
Posted: 22 April 2008 at 12:47pm

Dear @Lodep59
 
The how is possible in 1000 ways, we know that . The speed with loading is what counts. Do the test with:
 
Your solution (and myself included):
 
For Index = 0 To colCount - 1
    XtremeRecord.AddItem rs.Fields(Index).Value
Next
 
and with:
 
Baldur solution: (seems about 2 seconds faster, look my post above)
 
For Index = 0 To rs.Fields.Count - 1
    With XtremeRecord.AddItem(rs.Collect(Index))
         If IsNull(.Value) Then
             .Value = Empty
         End If
    End With
Next
 
 
 
 
]]> Tue, 22 Apr 2008 12:47:42 +0000 http://forum.codejock.com/forum_posts.asp?TID=10243&PID=34095&title=need-example-of-database-usage#34095