Rob:

Thank you for the reply.

This is a single user system (at this point) on a single lap top, no
network access. The DB is local and accessed with the FB embedded
version (2.1).
My "users" are all single user, health practitioners spread over US and
Europe, they are not connected to the same DB or on a network.

Nonetheless, this particular user is using the slow process I mentioned
with a set patient's record to methodically try out which loaded program
causes the problem. So, I'm guessing that is the best way to proceed? We
know that when it is slow it takes 11:15 minutes to finish, otherwise
about 1:30.

Thanks again,

Chuck

> Hi Chuck.
>
> If this is a large amount of data it could be simply network
> performance. One or more of your users other 20+ running apps might be
> using up some of his bandwidth. I would suggest making a test app that
> simply runs the SQL and loops through all the records (just filling a
> string) - should be quick and easy. have timing in the test app. Take
> it and run it a few times on a number of the machines on the site to
> confirm it really is just that users machine. If so try deactivating
> other apps (start with firwall and antivirus) to see which is the
> cause. It may be that this user (and the other couple you mentioned)
> are on the same network switch adn that there is an issue there.
>
> Hope this helps
> Rob
>
>
> On 9/02/2010 11:47 p.m., Chuck Belanger wrote:
>
>> Thank you, Daniel and Rob.
>>
>> This turned out to be a big factor according to my user, but there is a
>> point in the program which is still very slow:
>>
>> I make a sound file from the entire clinic session at the end in a Text
>> to Speech process to a WAV file then convert that to MP3.
>>
>> It's essentially a SELECT...DO WHILE NOT EOF...NEXT routine which does
>> numerous SQL for each record, too. The whole thing is being streamed
>> then converted to a file at the end, but the user reports the progress
>> meter, which just reports the record NEXT movement, is slow.
>>
>> Any thoughts on that as well? It's the same FDB.
>>
>> Thank you,
>>
>> Chuck Belanger
>>
>>
>>> Hi
>>>
>>> Check his anti virus settings, perhaps it is canning the FB DB every
>>> time a change is made. Does the database end with .gdb ? If so change it.
>>>
>>> Cheers
>>> Rob
>>>
>>>
>>> On 9/02/2010 10:28 a.m., Chuck Belanger wrote:
>>>
>>>
>>>
>>>> Hello, I've already asked this on the FireBird forum and got no replies:
>>>>
>>>> I'm using IBO and Firebird (2.1), embedded, in a desktop application.
>>>>
>>>> Recently, a user started really complaining that his program was very
>>>> slow (about 10x slower than other users). After coaxing him to try
>>>> running the program in Safemode in Vista, he noticed a MUCH better
>>>> response (i.e. in the ballpark of other users). He then methodically
>>>> looked at all his startup programs and processes and found a BlueTooth
>>>> program to be the culprit. He eliminated loading that, rebooted but then
>>>> found that there are other programs that are still slowing FB WAY down
>>>> (a recent grid which takes about 5 second to load, took him a minute to
>>>> load). He stopped looking but did not stop complaining about his "slow
>>>> program." : )
>>>>
>>>> Is there anyone who can help me to know what type of programs my users
>>>> should not be running with the DB intensive program that I distribute?
>>>> Are there specific issues here? Any general recommendations that I can
>>>> make to my users?
>>>>
>>>> Admittedly this user is one of those types that load up about 20 (and
>>>> I'm not exaggerating!) programs and expect them all to run just fine. He
>>>> does have plenty of RAM (I think he said 6Gb). He's running 32 bit Vista
>>>> on a laptop. Our support person does say that out of about 100 users
>>>> there are 2 others with similar problems, but they do not run a lot of
>>>> programs in the background.
>>>>
>>>> Thank you for any help.
>>>>
>>>> Chuck Belanger.
>>>>
>>>>
>>>> ------------------------------------
>>>>
>>>> ___________________________________________________________________________
>>>> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
>>>> without the need for BDE, ODBC or any other layer.
>>>> ___________________________________________________________________________
>>>> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
>>>> keyword-searchable FAQ, community code contributions and more ! Yahoo! Groups Links
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>> ------------------------------------
>>>
>>> ___________________________________________________________________________
>>> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
>>> without the need for BDE, ODBC or any other layer.
>>> ___________________________________________________________________________
>>> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
>>> keyword-searchable FAQ, community code contributions and more ! Yahoo! Groups Links
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>> [Non-text portions of this message have been removed]
>>
>>
>>
>> ------------------------------------
>>
>> ___________________________________________________________________________
>> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
>> without the need for BDE, ODBC or any other layer.
>> ___________________________________________________________________________
>> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
>> keyword-searchable FAQ, community code contributions and more ! Yahoo! Groups Links
>>
>>
>>
>>
>>
>>
>
>
> ------------------------------------
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
> keyword-searchable FAQ, community code contributions and more ! Yahoo! Groups Links
>
>
>
>
>

[Non-text portions of this message have been removed]