how many lines in a table?

} } Hi informixers! } We have a burning question to ask! : how big could be a table on SE engine } and work properly? I think "work properly " is something to consider. > Your only real limitation is space on your filesystem There is the factor of how long you plan to wait for transactions!!! } } More details : in 9 months of activity we have inserted almost 1,5 million } rows and this growth will continue in the future ... This is real heavy for an SE. I used to begin to see a performance hit after about 500,000 and that was with everything set up correctly running on a nice platform. Not only is the size a problem but 1.5mill in 9 months is a lot of traffic in a short amount of time for an SE -- depending on your application and the expectations for loads/transactions...-- I would seriously consider looking at reducing your data or moving towards an online engine:-) } } The Engine is a 5.00 SE and the HW is an IBM. ------- Mikea