Re: [ILUG] Splitting a large csv file > vfnkdycxsy@linux.ie > The problem is most likely neither your hardware nor your database size > - rather the data structure on the database and the indexing strategy. >   Look at the query plans generated by the general queries you're > running. They'll typically point you to the problems if you know what > you're looking for. I think your right the data structures is not very well optimised but it  can't be changed at this point in the game alass. Its looking like hardware it  upgrades will be the way forward. > Barry Flanagan  > man split > > NAME >        split - split a file into pieces > > SYNOPSIS >        split [OPTION] [INPUT [PREFIX]]  Thanks Barry; you where faster than google. Google was < helpful today. > Niall > Sorry, but this can only be described as a piece of string question?  > Faster than what at doing what, exactly? What are you searching on?  > Have you optimised your table? What indices are in place? Have you  > analysed your queries to see where the bottlenecks are? Questions,  > questions, I know - but these are the questions you need to be asking  > yourself.  We have been asking these questions but only too late. The data and the  app that uses it can't be changed meening the cost of new hardware is  less than the cost of a good programmer.  Thanks for the reply All. Tom