Android Question MySQL

[Holger Brauer]

First, I want to say thankyou for all the good ideas, solutions and tipps here in the forum. A great help for me as beginner. It is fantastic.

I have red many threads about MySQL but I miss some ground informations and the 'best way'. I use the simple .download2 method from HTTPutils2 and its working, but is this a good idea for a big database ? So what to do if you want to start a product and order database with ten thousands of records and about 400 users ? I read something about jRDC2, but did not understand full.

Best regards from Düsseldorf

 

[KMatle]

Size:

This doesn't matter. There's no real difference if there are 10 rows in a table or 100 Mio. Really important how you design your database and your app. Loading thousands of rows is a programming/design mistake (except you need all the data to work with). At my work we handle Billions of rows.

Users:

It's all about how many requests/traffic they procuce. Here you will have a server handling all those requests and the database system like MySQL. The more traffic, the more power you need.

Best way:

Hm. There are several. I don't like RDC because you have to use the usserid and pw inside the app which is absolutely unsafe. I prefer php scripts on the server handling all the db requests.

MySQL:

It's free but there are other db-systems which may match better (for companies). For the "normal" stuff, it's ok, even in production systems. If you get bigger, you need a lot of money (servers). Think about Facebook and what db storage they need.

Regards from Kerpen (near Cologne)

 

[Holger Brauer]

OK, understood, from the technical view, which tool is the easiest and beginners friendly to use with MySQL and B4A ?