My host does not support mySQl. I want to use DBMan but soon will my database be more than 1Mb in size. Due to size and therefore speed reasons, I will need to use SQL version of DBMan. Will I also not be able to use SQL version of DBMan?

My other question: I will have this database of directory of companies organised according to sectors. Very easily my database can grow over 60 thousand records. Each record would have the fields sector, subsector, company name, address, city, country, tel, fax, url, email, major product, major service fields. As I understand, the solution for me is a relational database with sql. Can I handle such a database with that structure and size with DBman SQL. If my host does not allow me to use sql version, is there a solution other than dbman that somebody can suggest me? I do not leave from my host because I like it there.

Tech data: they run on UNIX and perl 5.003, there is also perl 4

If it is not considered as advertising, I can also give the name of my host.

Thanks

Al

In order to be able to use the SQL version, your server must offer either mySQL or mSQL. Without one of those, there's no way for the SQL version to work.

I think that your database size will be such that the "regular" DBMan would become overworked pretty quickly. From my understanding, the SQL version would work, keeping in mind my first paragraph above.

The only other database formats I'm familiar with are using MSAccess and ASP. I understand that there is a way now for Unix servers to be able to use ASP, but I don't know anything specifically about it.

------------------
JPD

Where to get SQL version of DBman ?!?

It's not available on the site, you have to ask Alex for details. Email him on alex@gossamer-threads.com.

adam

ChiliSoft has software available for UNIX servers to run Active Server Pages (ASP).
ISPs have to install the software on their server.

For more information, check out

http://www.chilisoft.com/

Regarding SQL for NT...Does it run with DSN files with the ODBC driver or can it just run under mSQL or mSQL?

Our Class Schedule database has the potential to run over 1 MB and we would like to maintain the integrity and speed of the search capabilities.

Regards,


------------------
Eliot Lee
Founder and Editor
Anthro TECH, L.L.C
http://www.anthrotech.com/
info@anthrotech.com
==========================
Coconino Community College
http://www.coco.cc.az.us/
Web Technology
Coordinator
elee@coco.cc.az.us

Ok I understand the DBman without SQL version is not the solution for me. But still me wonders if the following is possible and practical:

Lets say I stay with Dbman standard. No SQL. I divide my database to different parts according to sectors. Lets say 6 or 10 smaller databases and each near 1 Mb size. One script controlling all. I let the user choose first in the form html in which sector they want to make the search. Than the DBMan goes to the database of this sector and does the search there. Does this solve the problem? If your answer is positive I have the following question. If my host starts supporting mSQL or MySQL in future, does my sectors divided DBMan databases could be implemented to DBMan SQL version (be transformed to one single database) and used similarly or would I need to start from start again.

Please make your answer simple for somebody who have almost no understanding of Perl, CGI and DBMan but is looking to find a way to solve his database problem. I must ask these questions before it is too late.

For the ASP solution, I will check this if there is no other way.

Thanks a lot for the support.

AL

If you are sure you wouldn't need a search to cover more than one of your sectors, you could do this. You would have to be certain that the user chose one of the sectors when they did the search. The way to do this is to not have a "none" sort of option in a select list.

I understand that you can transfer files from "regular" DBMan to SQL DBMan, but I don't know anything about how to do that. Alex will have to answer this part of your question.

------------------
JPD

Thank you for your help and patience with me

AL

Hi Al,

I would recommend convincing your ISP to install mysql (it's free) and using the SQL version. My experience has been that splitting a data file up can quickly become an admin nightmare. You may also want to consider switching providers.

As for upgrading to SQL, it's very easy. The html.pl file is the same, the config file is very similiar, and importing the data is really easy. Assuming things are set up on your server (you'll need perl 5.004+, DBI module and DBD module installed), then installation/upgrade is less then 10 min.


It does work with mSQL ( http://www.hughes.com.au ), but I highly recommend mysql ( http://www.mysql.com ). It will also work on NT machines using mysql or ODBC. You'll need to install the DBI module and the DBD::ODBC module (both available on CPAN).

Cheers,

Alex

Alex, where to get SCQ version of DBMAN ?! I presume it's not free.

Thanks Alex.
I have another question. I have used MS Access. In different websites I have read that the large sized databases should have a model called relational database model similar to that which can be set up with access. In fact it is suggested to me here too. In a relational database system, I know I must divide my database to meaningful tables and use the relations of tables to implement the queries.

Does DBMan SQL work this way too ?

If it is easy to use the same database file to switch to SQL version, I would think that it is not. Please forgive me if I am mixing things up. As I said before, I am new in these subjects and just learning.

Best regards,
AL

I'm interested in the SQL version. can I have more info on that? email me? ASAP

I want to do a website that allow people to register, entering their data.. and able to let other to search.

and also can put .wav/realaudio and...photo. not the hyperlink, but it will show out the photo.