> I have a requirement where my table needs around 2000 to 3000
> coloums . Is it advisable to create such a table in firebird . Is

No offence, but I really have my doubts about your design.

Firebird doesn't have a maximum number of columns perse, but
it does have a maximum row size, which can be calculated by
adding up all storage for the columns.

Why do you need so many columns?

> there any thumbrule on number of columns? Since ours is a conversion
> project from paradox and since paradox had a coloum limitation of
> 255 . We had to design in such a way that the records were stored row
> wise at the cost of speed . Now since we are using Fb we are planning
> to keep all the records coloum wise , since such a structuring
> improves the application speed performance (and also the db size will
> be reduced) .

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com