perfomance worry, with data insertions.

[gibbonuk]

Hi all, im just wondering in which direction to carry on along with the current project im assigned to.

 

Bascially, i provide a website for user to log into and look at data (2 byte values) inside a DB, there is about 70 per row.

 

Not huge triffic at all as its not a public website.

 

The worry i have though is getting the data "into" the DB, it will be entered from a delphi application NOT local on the server, and ideally i would like the data to be entered every minute. So inserting one row so 70 x 2 byte values every minute. But i may have 100 of these doing that?

 

Is that "alot" or should it be ok?

 

No server specific hardware at the moment as this is all in development, curren tly using a standard PC as a webserver.

 

Thanks

Andy

[fenway]

I don't understand this "every minute" requirement, nor the 70 x 2 restriction.

 

Can't you insert all 70 at once/

[gibbonuk]

Hi sorry to consuse you, what is meant by 70 x 2 bytes, is the insert will insert a row that has 70 columns, each with 2 bytes of data. So every minute, the delphi software will add a single row, with 70 columns and there maybe upto 100 delphi applications doing this, but each delphi application is inserting its data into a table of thier own.

 

The minute requirement is just because thats when the delphi application gets hold of the data.

 

Is this classed as excessive or not?

 

Thanks

Andy

[fenway]

Shouldn't be.