Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
May 6, 2005, 3:17 am
rate this thread
I usually can figure out anything by searching the groups or the net
all day, but this problem has been bugging me for awhile now.
I have multiple databases, all of which have the same 2 tables, and all
the same fields and field types. Each database holds a particular
vendors data, lets call them VDB1, VDB2, ... VDBX. Then I have a temp
database that is structured just like the VDBs, which is populated by a
script I wrote. My goal is to create a comma-seperated values (.CSV)
file, which includes all the records from the temp database, however,
I'd like to have 1 field's data prefixed and suffixed by the VDB's
number, if it's found in any one of the VDB's databases (ie. [XYX] if y
was found in VDBX, else [Y]).
Now, I already have this working using a script that does what I just
explained, however, it's not always working properly. It works, but
sometimes it does not output [XYX] even though Y was in X, or it does
not output all of the records from the temp database if the number of
records in the temp database is greater than approx. 1500.
Here's what I've been thinking... I believe it has to do with the the
numbers, the number of records in temp database, number of records in
the VDBs, and number of VDBs. When I first wrote this script, there was
no more then 10000 records in each VDB and the number of records in the
temp database have stayed the same, roughly 1000. And since it used to
work perfectly when the numbers where smaller, (now the number of
records in some of the VDBs are over 250k, and the number of VDBs is
now more then doubled), and I see that the PC is running at 100%
throughout the entire process, which means it might be hardware
So, the question is, should I work on rewriting the script and assume
that the method used to output the data is incorrect, or should I be
thinking about increasing the physical resources of the computer the
current script is running on (ie RAM/Processor/MB), or may there be
some settings in A/P/M that might need to be tweaked? I can show you
some psuedo-code of the script, but I'll need to ensure it's
confidentiality, since it's owned by a client.
Thanks for any insight you may have and please email any responses, as
I would like to work on solving this issue as soon as possible.
Clyde Development Corp.
Re: HELP: Pretty tough issue - lets see who can figure this one out?!?!
On 5-May-2005, email@example.com wrote:
With the limited info you provided, my guess is the 'script' is timing out.
tom (at) creative (dash) light (dot) com
do NOT send email to firstname.lastname@example.org (it's reserved for spammers)