Re: MS SQL 2005 CE and VB6

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


"newbie in hell" <newbieinhell@xxxxxxxxxxxxxxxxxxxxxxxxx> schrieb im
Newsbeitrag news:3683C17A-B2CB-4F25-BE52-5DC18E124BA4@xxxxxxxxxxxxxxxx

I've spend almost a week doing a complete research on
MS SQL 2005 CE just to find that MySQL is 1000%
more superior on performance. This is not what it is
said on the literature.
<g> ...no surprise, that's what we already told you in the
older threads.

And again, you only need to show us the field-definitions of
your three tables - how much Records each table should
contain - and your final SQL-Join-Code, that you want to
speed up.

Speaking for myself, I would post you an appropriate
example then, wich inserts Dummy-Data into tables that
meet your definitions and finally perform an adequate join
on them, just to show you, what speed you can expect,
if you do things right (regarding proper placed indexes, etc.).

Olaf




.

Relevant Pages