Subject | Re: [IBO] What other programs really slow down IBO/Firebird Embedded? |
---|---|
Author | Chuck Belanger |
Post date | 2010-02-09T10:47:14Z |
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
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[Non-text portions of this message have been removed]
>
> 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
>
>
>
>
>