Changing to C++ is not likely to give you a noticable speed difference
because your bottleneck is not the code but the queries. With proper
database design you should be able to acheive those results with one query,
and it should be fast if given the right indexes.
ryan
> I am searching to speed up an operation I have, which works - it just
> takes minutes to finish. The current script is written in pike (a C like
> scripting language). I believe that most of the overhead is the multiple
> queries. Would using C++ be significantly faster? (I'd have to learn
> some C before I could do this, so, the speed increase needs to be worth
> the effort).
>
> Let me explain the situation:
>
> Table 1 is defined as:
> MM;varchar(4)
> Title;varchar(48)
> Archive;varchar(4)
> record_num;int(8) unsigned zerofill
>
> I am given a list of Titles. With these Title's I need to search Table 1
> for the Title and output as follows:
>
> Green Mile 10 35mm TRLR 6 16mm BCAM
> Cast Away 4 35mm 20 BETA
>
> In the above example, Green Mile=Title 35mm=MM TRLR=Archive etc. So we
> have 10 35mm TRLR of Green Mile.
> Currently I am querying several times to get the result. This is slow
> because the list could be 50 Titles.
>
> Thanks for any advance you can give on this.
>
>
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
