Hello Gordon

Obvious question - is the database on the same machine as the app?

Why no way for stored procedure? or is that challenge for the community ;-)

Regards
Paul

> -----Original Message-----
> From: IBObjects@yahoogroups.com
> [mailto:IBObjects@yahoogroups.com] On Behalf Of Gordon Hamm
> Sent: 26 August 2008 05:26
> To: IBObjects@yahoogroups.com
> Subject: [IBO] Performance..
>
>
> Hi,
> Im using Firebird 2.1.
> I have a table that has about 8 fields of prices and a
> date/timestamp field.
> There are about 7 million records.
> There is only one index, and thats on the time stamp field.
> I have a routine that does a simple sql select and orders on
> the date/time field (That has an index)
>
> I then loop through the entire table, and do some complex
> math etc on the data.. top to bottom..
> Then, I do it again and again, testing some modeling
> parameters or "What if"
> stuff. I will litterally loop through it 500 times..
>
> No, there is no way to do this in a stored proc..
>
> Anyway, It works fine, but I was doing it on my pentium 4,
> took about 5 minutes for each iteration.
> memory usage was small, and CPU was only about 30 %.
>
> I went out and bought a quad core , with more memory, much
> faster cpu and bus, faster drives etc..
>
> Its only a tiny bit faster now.. Im so discouraged with it..
> I can imagine why its not many times faster..
>
> Any idea what the bottle neck might be? I am doing a
> unidirection query, to save memory, that helps, Im not using
> "Fieldbyname", getting the field directly by
> TempQuery.Fields.Fields[12].AsFloat.
>
> I dont know what else to do..
>
> Gordon
>
>
>
>
>
> ------------------------------------
>
> ______________________________________________________________
> _____________
> 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
>
>
>