MYSQL question....

[nullpointer]

---

...........

[nullpointer]

y man d i kng vb6 bro? ako vb6 man gani akong gamit...eheheh.....

VB6 is out of support from M$....

[dwardwarbinx]

Normalize! hehe. One thing I learned from school jud kay unsa ka-importante ang design sa system ug dapat normalized tanan tables.

[iamweasel]

Performance wise, do not store pictures on your mysql database, instead store it into a directory... Then store its filename and/or its location to a table, query these info and have your program point to the file location.

Database performance depends on your design and structure (either MS-SQL, MySQL, PostGre SQL, etc)...

Sa amo, we have been dealing with "Table Locking" issues due to design flaws (gibyaan sa mga developer nga nagkalitse-litse ang system) sa database (esp. union select queries), which led us to redesign and restructure our database (MySQL 5.0)...

IMO, it would also depend on your hardware resources. I have been involved in a project (6-7 years running) where we store images, byte streams of pdf, exe, doc, xls, etc. (all the files you can think of) to a MS-SQL database. We have over 1k sites and an average of 2k to 3k files for each site.

Better server hardware, better design and architecture (not saying our architecture is better though) can come a long way.

[sunduwu]

unsaon pag.himo ug Data Relation sa MySQL naa ba ang MySQL ana... kanang prehas sa MS Access

[i_furion]

index ra na bro

[YatakeTumbi]

gamit lang gyud ug indexing, nya i-normalize sad imo table para dli redundant. and dapat flexible jud ang entire database for future updates/changes sad.

[philbluefox]

yup.. sakto si Blacksheep666.. kng naa man image dapat isave lang sa directory nya ang filename lang ang ibutang sa database.

[ErapGuapo]

Question ko lang.. unsaon pag connect sa MySQL gamit ako program vb6 pinaagi sa ako public IP... ng.libog kaau ko kay dili ko ka connect kng LAN lang maka connect man ko?


please help... tnx

try using connection string....that would help you...

[ErapGuapo]

proper indexing ang usa sa maka tabang para pas2x ang performance sa imo DB regardless sa iyang sulod...