 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
VB Forum / Database Access / August 2005Recordset
Hi, I am trying to process a large amount of data and I need to get one record at a time. This is taking too long so I need to find a way to speed it up. I have one recordset (from a temp table) that contains individual records. I need to see if these records are in my live database tables. I do this by moving through my original recordset and then performing a select statement for each record to see if it is in my database. Is there a way to select a large amount of records from the live database tables so that I can then process each record of the original dataset by doing a select of the returned larger recordset? I hope this explanation isn't too muddy. Any help would be appreciated. Thanks, Ellie "Ellie" <nospam@nospam.net>'s wild thoughts were released on Tue, 30 Aug 2005 10:39:01 -0400 bearing the following fruit: >Hi, > [quoted text clipped - 8 lines] >returned larger recordset? I hope this explanation isn't too muddy. Any help >would be appreciated. When you select from the temp table, can't you do an outer join on the 'live' table? Jan Hyde (VB MVP)  Signature"Doc, I can't stop singing the green green grass of home." "That sounds like Tom Jones syndrome." "Is it common?" "It's not unusual." [Abolish the TV Licence - http://www.tvlicensing.biz/] I was thinking that. I'm having trouble since my select on the live table contains many left joins. I can keep at it though and see if I can get it to work. > "Ellie" <nospam@nospam.net>'s wild thoughts were released on > Tue, 30 Aug 2005 10:39:01 -0400 bearing the following fruit: [quoted text clipped - 22 lines] > > [Abolish the TV Licence - http://www.tvlicensing.biz/] "Ellie" <nospam@nospam.net>'s wild thoughts were released on Tue, 30 Aug 2005 11:48:43 -0400 bearing the following fruit: >I was thinking that. I'm having trouble since my select on the live table >contains many left joins. I can keep at it though and see if I can get it to >work. Why do you need many joins on the live data? Can't you reduce this? Are all these joins using indexes? J >> "Ellie" <nospam@nospam.net>'s wild thoughts were released on >> Tue, 30 Aug 2005 10:39:01 -0400 bearing the following fruit: [quoted text clipped - 28 lines] >> >> [Abolish the TV Licence - http://www.tvlicensing.biz/] Jan Hyde (VB MVP) SignatureBeyond: Sleepy Bee (J. A. Mc.) [Abolish the TV Licence - http://www.tvlicensing.biz/] Unfortunately I have many tables that I need data from in that query. However, I managed to get it work by putting the outer join at the end rather than trying to put it in the beginning of the query. Thanks for your help P.S. where did that "wild thoughts were released on..." in my address come from??? > "Ellie" <nospam@nospam.net>'s wild thoughts were released on > Tue, 30 Aug 2005 11:48:43 -0400 bearing the following fruit: [quoted text clipped - 49 lines] > > [Abolish the TV Licence - http://www.tvlicensing.biz/] "Ellie" <nospam@nospam.net>'s wild thoughts were released on Tue, 30 Aug 2005 14:57:46 -0400 bearing the following fruit: >Unfortunately I have many tables that I need data from in that query. >However, I managed to get it work by putting the outer join at the end [quoted text clipped - 3 lines] >P.S. where did that "wild thoughts were released on..." in my address come >from??? Same place the 'wrote in message' came from in mine ;-) J >> "Ellie" <nospam@nospam.net>'s wild thoughts were released on >> Tue, 30 Aug 2005 11:48:43 -0400 bearing the following fruit: [quoted text clipped - 55 lines] >> >> [Abolish the TV Licence - http://www.tvlicensing.biz/] Jan Hyde (VB MVP) SignatureThere was the ship carrying red paint that collided with another carrying blue paint. Both crews were marooned. [Abolish the TV Licence - http://www.tvlicensing.biz/] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.