Hi,

1- When i insert more than 30 datas (at once) into a table, does sequence cache size(20) effect anything because, i use sequence for auto increment in the table.
2-What happens if i increase the cache size from 20 to 50?

thanks

using the cache increases the performance but that can create problem in some circumstances also.

The cache size is how many Oracle will cache in memory, so when you first select a next value it will read the sequence from disk (n), and write back a next value of n+20. Then as you keep getting a next value it will just give you the next value from cache until all 20 have been used, then repeat the process.
The down side is that if the server crashes or is restarted, those sequence numbers cached in memory will be lost so if you only used 10 values - there will be a gap of 10 in the sequence. This may not be a problem, but some systems require all values to be accounted for ( e.g. some invoice systems )

Nige

It depends on wether you are inserting images, Or just text...

It depends on wether you are inserting images, Or just text...

Not sure what you mean by that? Wouldn't have thought the content would have affected it.

Nige

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.