Thread View: borland.public.cppbuilder.database.multi-tier
4 messages
4 total messages
Started by N. Karademir
Wed, 28 Nov 2001 12:29
what database should i use?
Author: N. Karademir
Date: Wed, 28 Nov 2001 12:29
Date: Wed, 28 Nov 2001 12:29
24 lines
1775 bytes
1775 bytes
Hi all, At the moment i have a program which uses paradox tables. Iam planning to port the appl. to an other database. which database should i use? below some information : The appl. will be use in a network environment. Untill 3 computers it must work in a peer-to-peer environment. (no dedicated server). if use of more then 3 computers we will setup a dedicated server.(win2000,NT,Linux,Novell) It must be possible for my customers to access for example the same record at one time.(not for editting). At the moment i have a paradox table which contains about 30 fields. After 1 year of working with the software their will be about 300.000 records. the second year 600.000 etc.etc. I also have an other table which also contains 30 fields and about 20.000 records. And I have about 10 tables whith a maximum of 200 records. Any tip would be welcome.
Re: what database should i use?
Author: Nick Rambarransingh
Date: Thu, 29 Nov 2001 15:18
Date: Thu, 29 Nov 2001 15:18
30 lines
2163 bytes
2163 bytes
Good Day 'N. Karademir", > > At the moment i have a paradox table which contains about 30 fields. After 1 > year of working with the software their will be about 300.000 records. > the second year 600.000 etc.etc. > I also have an other table which also contains 30 fields and about 20.000 > records. > And I have about 10 tables whith a maximum of 200 records. I would go with Paradox for as long as possible. 600 000 records is going to start to get "choppy" for Paradox, despite the the ability to handle up to 1 million records. If you are happy with the performance, then leave everything alone. The minute you decid to get a Server, or, the Paradox performance is not adequate, go to something like InterBase, MySql, and then MS SQL, perferable in that order. 1 - Interbase has got a fairly small foot print, and is a very robust DBMS. It is also inexpensive. 2 - MySql because it is free, and also has an average size DBMS engine. IT should not eat up too many resources on your computer. 3 - MS Sql because, well, let me think about that some more ...:-) Good Luck, Nick Borland Forever ...
Re: what database should i use?
Author: N. Karademir
Date: Sat, 01 Dec 2001 13:44
Date: Sat, 01 Dec 2001 13:44
55 lines
2433 bytes
2433 bytes
What about MySql. I this easy to implement in the appl.? What can you tell me about it? DOnt know nothing about it yet. thanks, N. Karademir "Nick Rambarransingh" <nrambarransingh@videotron.ca> schreef in bericht news:3C0651B8.9D2F232B@videotron.ca... > Good Day 'N. Karademir", > > > > > At the moment i have a paradox table which contains about 30 fields. After 1 > > year of working with the software their will be about 300.000 records. > > the second year 600.000 etc.etc. > > I also have an other table which also contains 30 fields and about 20.000 > > records. > > And I have about 10 tables whith a maximum of 200 records. > > I would go with Paradox for as long as possible. 600 000 records is going to > start to get "choppy" for Paradox, despite the the ability to handle up to 1 > million records. If you are happy with the performance, then leave everything > alone. > > The minute you decid to get a Server, or, the Paradox performance is not > adequate, go to something like InterBase, MySql, and then MS SQL, perferable in > that order. > > 1 - Interbase has got a fairly small foot print, and is a very robust DBMS. It > is also inexpensive. > > 2 - MySql because it is free, and also has an average size DBMS engine. IT > should not eat up too many resources on your computer. > > 3 - MS Sql because, well, let me think about that some more ...:-) > > Good Luck, > Nick > Borland Forever ... >
Re: what database should i use?
Author: a
Date: Tue, 18 Dec 2001 12:56
Date: Tue, 18 Dec 2001 12:56
67 lines
2745 bytes
2745 bytes
I would try MySQL first and then maybe Sybase's Adaptive Server Anywhere. I would never, ever use SQL server. Not only it it losy as a database solution but it is a MS product. N. Karademir <n.karademir@smart-software.org> wrote in message news:3c08dfb1$1_2@dnews... > What about MySql. > > I this easy to implement in the appl.? > > What can you tell me about it? > DOnt know nothing about it yet. > > thanks, > > > N. Karademir > > > "Nick Rambarransingh" <nrambarransingh@videotron.ca> schreef in bericht > news:3C0651B8.9D2F232B@videotron.ca... > > Good Day 'N. Karademir", > > > > > > > > At the moment i have a paradox table which contains about 30 fields. > After 1 > > > year of working with the software their will be about 300.000 > records. > > > the second year 600.000 etc.etc. > > > I also have an other table which also contains 30 fields and about > 20.000 > > > records. > > > And I have about 10 tables whith a maximum of 200 records. > > > > I would go with Paradox for as long as possible. 600 000 records is > going to > > start to get "choppy" for Paradox, despite the the ability to handle up to > 1 > > million records. If you are happy with the performance, then leave > everything > > alone. > > > > The minute you decid to get a Server, or, the Paradox performance is not > > adequate, go to something like InterBase, MySql, and then MS SQL, > perferable in > > that order. > > > > 1 - Interbase has got a fairly small foot print, and is a very robust > DBMS. It > > is also inexpensive. > > > > 2 - MySql because it is free, and also has an average size DBMS engine. > IT > > should not eat up too many resources on your computer. > > > > 3 - MS Sql because, well, let me think about that some more ...:-) > > > > Good Luck, > > Nick > > Borland Forever ... > > > >
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads