By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,770 Members | 1,180 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,770 IT Pros & Developers. It's quick & easy.

HELP: Pretty tough issue - lets see who can figure this one out?!?!

P: n/a
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
related.

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.

Frank
Clyde Development Corp.
Longmont, CO
720-652-0699
www.clydedevelopment.com
fr***@clydedevelopment.com

Jul 17 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Looks like Google removed my email address...
Here it is:
frank AT clydedevelopment DOT com

Thanks again.
Frank

Jul 17 '05 #2

P: n/a
fr*********@gmail.com wrote:
Looks like Google removed my email address...


Nope, it's there in all its glory, both inside your post and in your
headers.

Cheers,
Nicholas Sherlock
Jul 17 '05 #3

P: n/a

On 5-May-2005, fr*********@gmail.com wrote:
...
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.
...


With the limited info you provided, my guess is the 'script' is timing out.
See
http://www.php.net/manual/en/functio...time-limit.php

--
Tom Thackrey
www.creative-light.com
tom (at) creative (dash) light (dot) com
do NOT send email to ja*********@willglen.net (it's reserved for spammers)
Jul 17 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.